Independent practice · SQLite

Find customers without orders

Your task

Target: 70/100. Suggested active time: 10 minutes. You can keep working after that.

Show a hint

After LEFT JOIN, test the right-side order_id with IS NULL.

View the scoring standard

Accuracy checks the values. Coverage checks the requested output. Time is recorded separately and never changes your score.

columns: 20 points

rows: 80 points

Tables and practice data

order_id	customer_id	status	amount	region	ordered_at
1	1	paid	120	East	2026-09-01
2	2	pending	140	West	2026-09-02
3	1	paid	100	East	2026-09-03
4	3	paid	180	West	2026-09-03
5	99	paid	80	East	2026-09-04
6	NULL	cancelled	0	NULL	2026-09-04
7	2	paid	120	West	2026-09-05
8	4	paid	30	North	2026-09-06

Active 0:00 · Paused 0s

SQL query

Import answer

Show the reference answer

SELECT c.customer_id,c.name FROM customers c LEFT JOIN orders o ON c.customer_id=o.customer_id WHERE o.order_id IS NULL

Sky has no orders. Do not filter on customer email.