select date_format(event_time,"%Y-%m") month,sum(total_amount) GMV
from tb_order_overall
where status<2 and year(event_time)=2021
group by month
having GMV>100000
order by GMV;

确定输出格式

确定取值范围

分组求和

排序