select t1.*,t2.second_year_mon,t2.second_year_cnt from (select job,date_format(date,"%Y-%m") as first_year_mon,sum(num) as first_year_cnt from resume_info where year(date)="2025" group by job,date_format(date,"%Y-%m")) t1 left outer join (select job,date_format(date,"%Y-%m") as second_year_mon,sum(num) as second_year_cnt from resume_info where year(date)="2026" group by job,date_format(date,"%Y-%m")) t2 on t1.job=t2.job and substring(t1.first_year_mon,6,2)=substring(t2.second_year_mon,6,2) order by first_year_mon desc,job desc