select
left(t_time,7) time
,sum(t_amount) total 
from trade 
where left(t_time,4) = '2023' and t_cus = (select c_id from customer where c_name = 'Tom') and t_type = '1'
group by 1
order by 1