with tiaojian as (
select
date_format(t_time,"%Y-%m") as time,
t_cus,
sum(t_amount) as total
from trade
where
t_type=1
and
year(t_time)=2023
group by date_format(t_time,"%Y-%m"),t_cus
)


select 
time,
total
from tiaojian t inner join customer c 
on t.t_cus=c.c_id
where
c_name="Tom"
order by time