This lab adds two small tables, sizes and colours, to the shop.
- Think before you run it: how many rows does
sizes CROSS JOIN coloursreturn? Read the row count of each tab. - Every size with every colour:
size, thencolour. - Think before you run it: how many rows does
SELECT * FROM orders, customers;return? - Each order with its customer: the order id, then the customer's name. Start from the comma form and add a condition in
WHERE. - Every size of the Container Crab Tee: the product name, then the size.