Skip to content
RED SAGSkills
medium10 pts · first answer countssqlnull-handling

NOT IN with a NULL in the list

customers has ids 1, 2, 3. blocked.customer_id has the values 2 and NULL. What does this query return?

SELECT COUNT(*) FROM customers
WHERE id NOT IN (SELECT customer_id FROM blocked);
Choose one answer