参考答案 select s1.job, left(s1.date,7) as 'first_year_mon', s1.cnt as'first_year_cnt', left(s2.date,7) as 'second_year_mon', s2.cnt as 'second_year_cnt' from ( select job, date,sum(num) cnt from resume_info where year(date) = '2025' group by job ,month(date)) s1 join ( select job, date...