select date_format(t_time, '%Y-%m') as time, sum(t_amount) as total
from trade t join customer c on t.t_cus=c.c_id
where year(t_time)=2023 and c_name='Tom' and t_type=1
group by date_format(t_time, '%Y-%m')
order by time