SELECT
date_format( event_time, "%Y-%m" ) `month`,
sum( total_amount ) `GMV`
FROM
tb_order_overall
WHERE
`status` IN ( 0, 1 ) and year(event_time)=2021
GROUP BY `month`
having GMV>100000
ORDER BY GMV asc;
SELECT
date_format( event_time, "%Y-%m" ) `month`,
sum( total_amount ) `GMV`
FROM
tb_order_overall
WHERE
`status` IN ( 0, 1 ) and year(event_time)=2021
GROUP BY `month`
having GMV>100000
ORDER BY GMV asc;