题解 | #计算商城中2021年每月的GMV#
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
本题不难，读懂题意，直接上手写sql就行了，sql如下：
SELECT DATE_FORMAT(event_time,'%Y-%m') month, ROUND(SUM(IF(`status` = 1 OR `status` = 0, total_amount, 0)),0) GMV FROM tb_order_overall WHERE YEAR(event_time) = '2021' GROUP BY DATE_FORMAT(event_time,'%Y-%m') HAVING GMV > 100000 ORDER BY GMV;
查看20道真题和解析