题解 | #商品交易(网易校招笔试真题)#

```WITH t AS ( SELECT *, DATE_FORMAT( event_time, "%Y-%m" ) AS year_mont FROM tb_order_overall ) SELECT
t.year_mont AS MONTH,
ROUND( sum( t.total_amount ), 0 ) AS GMV 
FROM
	t 
WHERE
	YEAR ( t.event_time ) = "2021" 
	AND t.STATUS != 2 
GROUP BY
	t.year_mont 
HAVING
	GMV > 100000 
ORDER BY
	GMV ASC
	;