题解 | 计算商城中2021年每月的GMV（GMV 只算进帐！）
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
select month,
sum(total_amount) as GMV
from (
select left(event_time,7) as month,
total_amount
from tb_order_overall
where year(event_time)=2021 and status!=2
) a
group by month
having sum(total_amount) >100000
order by GMV
