select date_format(event_time,"%Y-%m") as month,sum(case when `status`=2 then 0 else total_amount end)as GMV
from tb_order_overall
where year(event_time)=2021
group by date_format(event_time,"%Y-%m")
having GMV>100000
order by GMV
select date_format(event_time,"%Y-%m") as month,sum(case when `status`=2 then 0 else total_amount end)as GMV
from tb_order_overall
where year(event_time)=2021
group by date_format(event_time,"%Y-%m")
having GMV>100000
order by GMV