#shengxu #2021nian #meiyue #gmv>10w shuchu # gmv shi 0 +1 #baoliuzhengshu select date_format(event_time,'%Y-%m') as month,round(sum(total_amount),0) as GMV from tb_order_overall tb where year(event_time )='2021' and (tb.status= 0 or tb.status=1) group by month having GMV>100000 order by GMV asc