SELECT 
DATE_FORMAT(t1.t_time,'%Y-%m') time,
SUM(t1.t_amount) total
FROM trade t1,customer t2
WHERE t2.c_name = 'Tom'
AND t1.t_time BETWEEN '2023-01-01' AND '2023-12-31'
AND t1.t_type = 1
AND t1.t_cus = t2.c_id
GROUP BY DATE_FORMAT(t1.t_time,'%Y-%m')
ORDER BY time