Independent practice · SQLite

Attach names to every order

Your task

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

Show a hint

Use LEFT JOIN and preserve SQL 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 o.order_id, c.name FROM orders o LEFT JOIN customers c ON o.customer_id=c.customer_id

An inner join drops order 5 and order 6. Join on the ID.