Skip to content
RED SAGSkills
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);
Choose one answer