All SQL problems
MediumJOIN
Which customer placed each order?
Join orders with customers so each order row shows the customer name and city. Return order id, customer name, city, order date. Sort by order id.
- #inner-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
18 orders + 10 customers
Expected shape
18 rows
sql-inner-join.sqlSQLite
Result
Press “Run query” to execute against the sample database.