Skip to main content
PProfileMatch

Advanced SQL · SQL Subqueries, UNION, INTERSECT, EXCEPT and CASE for Reporting

Question 1 of 5

Which names does this NOT IN query return?

CREATE TABLE p (id, name);
INSERT INTO p VALUES (1,'a'), (2,'b'), (3,'c');
CREATE TABLE v (pid);
INSERT INTO v VALUES (1), (NULL), (3);

SELECT name FROM p WHERE id NOT IN (SELECT pid FROM v);

Tip: press 1-4 to answer, Enter to continue. Finish the quiz to bank your XP.