题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT time,SUM(t_amount) AS total
FROM (
SELECT t_id,date_format(t_time,'%Y-%m') AS time, t_cus, t_amount,c_name
FROM trade t, customer c
WHERE t_type=1 AND t.t_cus=c_id AND c_name='Tom' AND year(t_time)=2023
) sub
GROUP BY time
order by time
查看17道真题和解析
天翼支付科技有限公司公司福利 19人发布