Query a real database

Sample dataset

• customers — id, name, city, loyalty_points
• products — id, name, category, price, stock
• orders — id, customer_id, product_id, quantity, order_date
• order_items — id, order_id, product_id, quantity

Try a query

• All products under £20
• Orders with customer names
• Revenue per product
• Out-of-stock products