Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Set operations

Theater is better

Report a typo

Consider two tables, stage_actors and movie_actors:

Data Schema

Select the query with the following result:

Query result

Select one option from the list

SELECT name FROM stage_actors UNION SELECT name FROM movie_actors

SELECT name FROM stage_actors INTERSECT SELECT name FROM movie_actors

SELECT name FROM movie_actors MINUS SELECT name FROM stage_actors

SELECT name FROM stage_actors MINUS SELECT name FROM movie_actors

___

Create a free account to access the full topic