Big orders with customer and product

Easy

Question

An online shop stores customers, products and orders in three tables. Each order is for one product, with a quantity.

Find every order whose total is at least 1000 rupees. The total of an order is the quantity times the price of the product.

Return order_id, customer (the customer name), product (the product name) and order_total.

Sort by order_total from high to low. If two orders have the same total, the smaller order_id comes first.

The order of the rows matters for this question.

join
inner join
multi table
order by

Read first: Lesson 44, SQL joins: inner, left, anti-join and self-join

Tables

3 tables

These are the example rows. Run uses only these rows. Submit also tests your query on a second set of rows that you cannot see.

customers3 columns · 5 rowsnot run yet

CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT NOT NULL, city TEXT NOT NULL);

Example rows of the customers table
id	name	city
1	Aarav	Mumbai
2	Diya	Delhi
3	Kabir	Pune
4	Isha	Mumbai
5	Rohan	Delhi

products3 columns · 6 rowsnot run yet

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT NOT NULL, price INTEGER NOT NULL);

Example rows of the products table
id	name	price
1	Notebook	120
2	Headphones	1499
3	Water Bottle	350
4	Desk Lamp	800
5	Backpack	1250
6	Pen Set	250

orders5 columns · 11 rowsnot run yet

CREATE TABLE orders (id INTEGER PRIMARY KEY, customer_id INTEGER NOT NULL REFERENCES customers(id), product_id INTEGER NOT NULL REFERENCES products(id), quantity INTEGER NOT NULL, ordered_at TEXT NOT NULL);

Example rows of the orders table
id	customer_id	product_id	quantity	ordered_at
1	1	2	1	2026-03-01
2	1	1	5	2026-03-02
3	2	3	3	2026-03-02
4	3	4	1	2026-03-03
5	4	5	1	2026-03-04
6	2	1	10	2026-03-05
7	5	6	4	2026-03-05
8	3	6	3	2026-03-06
9	4	4	2	2026-03-07
10	5	2	1	2026-03-08
11	1	3	2	2026-03-09

About this SQL

This works the same in Postgres and MySQL. In SQLite, ORDER BY may use a SELECT alias (ORDER BY order_total) or a column number (ORDER BY 4 DESC). Whole numbers multiplied by whole numbers stay whole numbers.

SQLite

Opening the code editor…

Result

Run shows what your query gives on the example rows.Submit checks it on the example rows and on a hidden set of rows.

SQL · ready