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