Independent practice · SQLite

Find paid orders with unmatched customer IDs

Your task

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

Show a hint

Combine the paid condition with the missing joined ID.

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 o.order_id,o.customer_id FROM orders o LEFT JOIN customers c ON o.customer_id=c.customer_id WHERE o.status='paid' AND c.customer_id IS NULL

Order 5 references 99. Cancelled NULL-key order 6 is not paid.