hard20 pts · first answer countssqldebugging
NOT IN returns no rows
banned_users has one row where user_id is NULL. How many rows does this query return?
SELECT id FROM users WHERE id NOT IN (SELECT user_id FROM banned_users);
banned_users has one row where user_id is NULL. How many rows does this query return?
SELECT id FROM users WHERE id NOT IN (SELECT user_id FROM banned_users);