SELECT
	DATE_FORMAT(t.t_time, '%Y-%m') AS time,
    ROUND(SUM(t.t_amount),1) AS total
FROM trade t
JOIN customer c ON t.t_cus = c.c_id
WHERE c.c_id = 101 AND YEAR(t.t_time)=2023 AND t.t_type=1
GROUP BY time
ORDER BY time