SQL EXISTS vs IN Quiz

This SQL quiz compares EXISTS and IN subqueries and their negated forms. You will see why NOT IN returns no rows when the list contains a NULL, how NOT EXISTS avoids it and what really differs between the two in modern databases.

Medium 10 questions ~6 minutes Pass at 80% SQLite

Choose a mode

Playing as a guest: sign in to keep your XP and streak.

Sample question

Question 1 of 10

What does this print?

CREATE TABLE customers (id INTEGER, name TEXT);
CREATE TABLE orders (id INTEGER, customer_id INTEGER);
INSERT INTO customers VALUES (1, 'Ann'), (2, 'Bob'), (3, 'Cy');
INSERT INTO orders VALUES (10, 1), (11, 1), (12, 3);
SELECT name
FROM customers c
WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id)
ORDER BY name;
Show the answer

B. Ann Cy EXISTS is true when the correlated subquery finds at least one row for that customer. Like IN, it never repeats a customer, no matter how many orders match.

What this quiz covers

  • EXISTS (correlated subquery) and its select list
  • IN vs EXISTS for semi-joins
  • The NOT IN with NULL trap
  • Fixing it with NOT EXISTS or IS NOT NULL
  • How optimizers treat IN and EXISTS

Questions people ask

Do I need an account?

No. Anyone can play. Sign in to keep your XP, streak, badges and history.

Can I retake it?

Yes. Your best score is kept, and the questions and answers are shuffled each time.