select date_format(event_time, '%Y-%m') as month, sum(total_amount) as GMV from tb_order_overall too where too.status in (1, 0) and year(event_time) = "2021" group by month having GMV > 100000 order by GMV asc; 按month分组,再聚合求total_amount的值