All SQL problems
MediumJOIN
Every order line, with product + customer
Join order_items with orders, customers, and products so each row shows customer name, product name, quantity, and price. This is what "denormalise for a dashboard" looks like.
- #multi-join
Schema (SQLite, in-browser)
customers (id, name, city, signup_date) products (id, name, category, price) orders (id, customer_id, order_date, status) order_items (order_id, product_id, quantity)
Sample input
26 order items
Expected shape
26 rows × 4 cols
sql-multi-join.sqlSQLite
Result
Press “Run query” to execute against the sample database.