Loadingone moment…
Sign in to run and submit your work
Reading is open to everyone. Running code and saving drafts need an account so your work is yours and comes back on your next visit.
or
CODE WORKSPACE
Return order_id and snapshot_count for every order_id that appears more than once in order_snapshots.
Result columns · in this order
order_idsnapshot_countHow to approach it
Group by the key that should be unique, then keep the groups whose count is above one.
Sample input
| order_id | status | updated_at |
|---|---|---|
| 1001 | paid | 2026-01-12 09:00:00 |
| 1001 | shipped | 2026-01-13 10:00:00 |
| 1002 | paid | 2026-01-12 10:30:00 |
| 1004 | paid | 2026-01-15 14:30:00 |
| 1004 | shipped | 2026-01-16 12:20:00 |
| 1008 | shipped | 2026-01-26 10:30:00 |
6 rows — all rows shown.
Expected output
| order_id | snapshot_count |
|---|---|
| 1001 | 2 |
| 1004 | 2 |
2 rows — all rows shown.
Constraints
GROUP BY order_id and keep only groups with COUNT(*) > 1. Order by snapshot_count DESC, then order_id ASC.
Expected skills
Duplicate-key detection with GROUP BY and HAVING.
Submit for review to find out what your query gets right, what it gets wrong, and how it compares with the best working query for this exercise.
This scenario runs a full workspace — editor, canvas and results side by side. It needs a laptop or desktop to be usable. Open this page on a bigger screen to start building.