题解 | 计算商城中2021年每月的GMV
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
SELECT DATE_FORMAT(event_time, '%Y-%m') AS month,
SUM(total_amount) AS GMV
FROM tb_order_overall
WHERE status = 1 OR status = 0 AND DATE_FORMAT(event_time, '%Y') = '2021'
GROUP BY DATE_FORMAT(event_time, '%Y-%m')
HAVING GMV > 100000
ORDER BY GMV
天翼支付科技有限公司公司福利 19人发布
查看4道真题和解析
