题解 | #获取指定客户每月的消费额#

#现需要查询 Tom 这个客户在 2023 年每月的消费金额（按月份正序显示）

#2023 tom 每月 消费 消费金额

with mon_tom_23 as
(select
*,
date_format(t_time,'%Y-%m') as mon
from trade t left join customer c
on t.t_cus=c.c_id
where year(t.t_time)=2023 and c.c_name='Tom' and t.t_type = 1

)

select 
mon as time
,sum(t_amount) as total
from mon_tom_23
group by mon
order by mon