题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT DATE_FORMAT(t1.t_time,'%Y-%m') time, SUM(t1.t_amount) total FROM trade t1,customer t2 WHERE t2.c_name = 'Tom' AND t1.t_time BETWEEN '2023-01-01' AND '2023-12-31' AND t1.t_type = 1 AND t1.t_cus = t2.c_id GROUP BY DATE_FORMAT(t1.t_time,'%Y-%m') ORDER BY time
查看17道真题和解析
