Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Set operations

Theory

Teachers and tutors

Report a typo

Match the queries with the number of rows in the result set.

Tables teachers and tutors look as follows:

Data table

Match the items from left and right columns
SELECT name FROM tutors UNION ALL SELECT name FROM teachers
SELECT name FROM tutors UNION SELECT name FROM teachers
SELECT name FROM tutors INTERSECT SELECT name FROM teachers
SELECT name FROM tutors EXCEPT SELECT name FROM teachers
2
4
1
6
___

Create a free account to access the full topic