easyShopee · aggregation
Orders by status
Shopee wants a quick breakdown of its orders.
From the orders table, return each status and the number of orders with that status as order_count.
Schema
▸orders
| id | INT |
| status | TEXT |
| amount | NUMERIC(8,2) |
Example input
▸orders
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.