select t1.date1, sum(if(t1.total_amount > 0,t1.total_amount,0)) GMV from ( select date_format(tb.event_time,'%Y-%m') date1, total_amount
from tb_order_overall tb where year(event_time) = 2021) t1 group by t1.date1 having GMV > 100000 order by GMV