题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT
DATE_FORMAT(t_time, '%Y-%m') as time,
SUM(t_amount) as total
FROM trade t
JOIN customer c ON c.c_id = t.t_cus
WHERE t_type = 1
AND c_name = 'tom'
AND DATE_FORMAT(t_time, '%Y-%m') LIKE '2023%'
GROUP BY DATE_FORMAT(t_time, '%Y-%m')
ORDER BY time;
