题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT
DATE_FORMAT(t.t_time, '%Y-%m') AS time,
ROUND(SUM(t.t_amount),1) AS total
FROM trade t
JOIN customer c ON t.t_cus = c.c_id
WHERE c.c_id = 101 AND YEAR(t.t_time)=2023 AND t.t_type=1
GROUP BY time
ORDER BY time
OPPO公司福利 1229人发布