题解 | #计算商城中2021年每月的GMV#
计算商城中2021年每月的GMV
http://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
SELECT
date_format( event_time, "%Y-%m" ) `month`,
sum( total_amount ) `GMV`
FROM
tb_order_overall
WHERE
`status` IN ( 0, 1 ) and year(event_time)=2021
GROUP BY `month`
having GMV>100000
ORDER BY GMV asc;