SELECT SUBSTRING(event_time, 1, 7) AS month,
ROUND(SUM(total_amount), 0) AS GMV
FROM tb_order_overall
WHERE YEAR(event_time) = '2021'
AND status BETWEEN 0 AND 1
GROUP BY month
HAVING SUM(total_amount) > 100000
ORDER BY GMV
SELECT SUBSTRING(event_time, 1, 7) AS month,
ROUND(SUM(total_amount), 0) AS GMV
FROM tb_order_overall
WHERE YEAR(event_time) = '2021'
AND status BETWEEN 0 AND 1
GROUP BY month
HAVING SUM(total_amount) > 100000
ORDER BY GMV