题解 | #计算商城中2021年每月的GMV#
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
此题虽然简单，但也需要仔细审题~
参考代码
SELECT month,sum(total_amount)GMV FROM (SELECT date_format(event_time,'%Y-%m')month,total_amount FROM tb_order_overall WHERE status<2 AND year(event_time)=2021)tb_order GROUP BY month HAVING GMV>100000 ORDER BY GMV;
运行结果
查看9道真题和解析
