SELECT DATE_FORMAT(event_time,'%Y-%m') as month ,round(sum(case when total_amount<0 then 0 else total_amount end),0) as GMV from tb_order_overall where DATE_FORMAT(event_time,'%Y') = 2021 group by month HAVING GMV > 100000 order by GMV
投递中原银行等公司10个岗位 >