题解 | #计算商城中2021年每月的GMV#
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
select month,sum(total_amount) as GMV from ( select uid, date_format(event_time,'%Y-%m')month,total_amount from tb_order_overall where status = 1 or status = 0 and year(event_time) = 2021 ) t1 group by month having GMV>100000 order by GMV
本题难度不大，根据月份聚合之后求出status =0 or status =1 的值即可。
查看18道真题和解析
蚂蚁集团一面259人在聊