题解 | 计算商城中2021年每月的GMV

select * from(
select date_format(event_time,'%Y-%m') as month,
sum(total_amount) as GMV_month
from tb_order_overall
where year(event_time)=2021
and status!=2
group by date_format(event_time,'%Y-%m')
order by GMV_month)a
where  GMV_month>100000

简单