题解 | #计算商城中2021年每月的GMV#
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
select DATE_FORMAT(event_time,'%Y-%m') x1,sum(total_amount) x2
from tb_order_overall t1
where status != 2 and DATE_FORMAT(event_time,'%Y') = 2021
group by DATE_FORMAT(event_time,'%Y-%m')
having sum(total_amount) > 100000
order by x2

查看4道真题和解析