D8LooPFocus modeCODE WORKSPACE
Read the status distribution
Return status and orders, the count of orders for each status, grouped by status and ordered by orders descending, then status ascending.
GROUP BY status with COUNT(*) AS orders, then ORDER BY orders DESC, status ASC.
Sample input
ordersAll 12 orders (order_id and status shown).
| order_id | status |
|---|---|
| 1001 | paid |
| 1002 | paid |
| 1003 | pending |
| 1004 | shipped |
| 1005 | paid |
| 1006 | refunded |
| 1007 | paid |
| 1008 | shipped |
| 1009 | pending |
| 1010 | paid |
| 1011 | paid |
| 1012 | shipped |
Expected output
Expected outputCounts per status, most common first. A grouped count is the fastest way to sanity-check a status column.
| status | orders |
|---|---|
| paid | 6 |
| shipped | 3 |
| pending | 2 |
| refunded | 1 |
Constraints
Use GROUP BY status with COUNT(*) aliased as orders. Order by orders DESC, then status ASC so ties are deterministic.
Expected skills
Grouped counts as a distribution sanity check and deterministic ordering of grouped results.
SQL
Loading...
AI evaluation
Run the SQL query to inspect preview rows.