Set Operations
2 / 10
EasyOutput prediction

INTERSECT returns common rows

Given these tables:

table_a:

name
Alice
Bob
Carol

table_b:

name
Bob
Carol
Dave

What does this query return?

SELECT name FROM table_a
INTERSECT
SELECT name FROM table_b;

← → arrow keys to navigate

Sign in to save your progress.