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



京公网安备 11010502036488号