Customers, products, orders and reviews. Every online store runs on a database like this one.
6 tables · 2,375 rows
One table: selecting, sorting, conditions
Grouping, counting, joining two tables
Subqueries, several JOINs, window functions
The lines show foreign keys: which table points to which.
Product categories
Products
category_id → categories.id
Reviews
product_id → products.idcustomer_id → customers.id
Customers
Orders
customer_id → customers.id
Order lines
order_id → orders.idproduct_id → products.id