hard20 pts · first answer countssqldebugging
NOT IN with a NULL in the list
What does this query return?
-- customers: id 1, 2, 3 -- banned: customer_id 2, NULL SELECT id FROM customers WHERE id NOT IN (SELECT customer_id FROM banned);
What does this query return?
-- customers: id 1, 2, 3 -- banned: customer_id 2, NULL SELECT id FROM customers WHERE id NOT IN (SELECT customer_id FROM banned);