Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Set operations

School dancers

Report a typo

Choose a correct query that selects all distinct names that appear both in the table pupils (name VARCHAR(40), form INT, school_num INT) and table dancers (name VARCHAR(40), dance_style VARCHAR(30), experience INT).

Select one option from the list

SELECT name FROM pupils INTERSECT SELECT name FROM dancers

SELECT name FROM pupils EXCEPT SELECT name FROM dancers

SELECT name FROM pupils UNION SELECT name FROM dancers

SELECT name FROM pupils UNION ALL SELECT name FROM dancers

___

Create a free account to access the full topic