题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select
date_format(t_time, '%Y-%m') time,
# month(t_time) time,
sum(t_amount) total
from
customer c
left join trade t on t_cus=c_id
where c_name='Tom' and year(t_time)=2023 and t_type=1
group by time
order by time
荣耀一面242人在聊