我是肺物我原来的题解： select date_format(t.t_time, '%Y-%m') time, round(sum(t.t_amount), 1) total from trade t join customer c on t.t_cus = c.c_id where t.t_type = 1 and c.c_name = 'Tom' and year(t.t_time) = '2023' group by t.t_time, c.c_id order by time asc; 答案题解： SELECT DATE_FORMAT(t.t_time, '%Y-%m') AS tim...
查看21道真题和解析