select 
substr(t_time,1,7) as time,
sum(t_amount) total


from trade join customer on trade.t_cus=customer.c_id
where c_name='Tom' and year(t_time)='2023' and t_type='1'

group by substr(t_time,1,7)

order by substr(t_time,1,7)