题解 | 计算商城中2021年每月的GMV
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
WITH tb1 AS(
SELECT DATE_FORMAT(event_time, '%Y-%m') AS month,
ROUND(SUM(total_amount),0) AS GMV
FROM tb_order_overall
WHERE total_amount > 0 AND YEAR(event_time) = 2021
GROUP BY month
)
SELECT month,
GMV
FROM tb1
WHERE GMV > 100000
ORDER BY GMV ASC
- ROUND(SUM(total_amount),0) AS GMV 不能和 WHERE GMV > 100000 一起出现