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