上个月每个地区的订单数和销售额是多少?按销售额降序排列
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 |