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