先月、地域ごとの注文数と売上はいくらでしたか?売上の降順で並べてください。
SELECT
region,
COUNT(*) AS order_count,
SUM(amount) AS sales_amount
FROM orders
WHERE created_at >= date_trunc('month', now() - interval '1 month')
GROUP BY region
ORDER BY sales_amount DESC; | region | order_count | sales_amount |
|---|---|---|
| 華東 | 1280 | 1,294,567.00 |
| 華南 | 950 | 987,654.00 |
| 華北 | 860 | 765,432.00 |