Draw the chain of tables for each task before you write it. The link icons in the table tabs show the foreign keys.
- Every order item: the order id, the product name, then the
quantity. - Every order item with the customer who bought it: the customer's name, then the product name.
- The names of the products that Ava Chen bought.
- How many different customers bought the Kraken Plush?
- Every order item with its product and category: the order id, the product name, then the category name. The item with no category must be in the result.