Write one join for each task. The task gives the columns and their order.

1. Every order with its customer: the customer's name, then the order's id and status.
2. Think before you run it: how many rows does products JOIN categories on the category id return?
3. Every product with its category: the product name, then the category name.
4. Orders from customers in Canada (CA): the order's id, then the customer's name.