- Think before you run it: how many rows does
customers c LEFT JOIN orders o ON o.customer_id = c.idreturn? - Every customer with the id of each of their orders: the customer's
name, then the orderid. Customers without orders must be in the result. - The names of the categories that have no products.
- Every product with its category name: the product name, then the category name. Mystery Box must be in the result.
- The names of the departments that have no employees.