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