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.