题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT
DATE_FORMAT(t_time,"%Y-%m") AS time,
SUM(t_amount) AS total
FROM trade
WHERE t_cus = 101 AND YEAR(t_time) = 2023 AND t_type = 1
GROUP BY DATE_FORMAT(t_time,"%Y-%m")
ORDER BY DATE_FORMAT(t_time,"%Y-%m") ASC
