Orders by Status
The operations dashboard shows how many orders are in each status. Return status and cnt, one row per status, sorted by status.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| cnt | status |
|---|---|
| 1 | cancelled |
| 3 | paid |
| 3 | pending |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in