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);