Some cells in the tables are NULL. Find them, and make sure that your conditions do not lose them by mistake.
- The customers with no email:
name, thenemail. - The products with no category:
name, thencategory_id. - Think before you run it: how many rows does
SELECT name, category_id FROM products WHERE category_id <> 3;return? The table has 12 products. - Every product that is not in category 3 (Stickers), also the products with no category:
name, thencategory_id. - The employees who have a manager:
name, thenmanager_id.