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

select date_format(event_time,"%Y-%m"),round(sum(total_amount),0)
from tb_order_overall
where status!=2 and date_format(event_time,"%Y")=2021
group by 1
having sum(total_amount) >100000
order by 2 asc