题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT DATE_FORMAT(t.t_time, '%Y-%m') AS time, SUM(t.t_amount) AS total FROM trade AS t LEFT OUTER JOIN customer AS c ON t.t_cus = c.c_id WHERE c_name = 'Tom' AND t.t_type = 1 AND YEAR(t.t_time) = 2023 GROUP BY DATE_FORMAT(t.t_time, '%Y-%m') ORDER BY time;
查看20道真题和解析