select a.job,a.first_year_mon,a.first_year_cnt,b.second_year_mon,b.second_year_cnt from 
(select job,left(date,7) as first_year_mon,month(date) as m,sum(num) as first_year_cnt from resume_info
where year(date)=2025
group by job,first_year_mon,m
) a
join
(select job,left(date,7) as second_year_mon,month(date) as m,sum(num) as second_year_cnt from resume_info
where year(date)=2026
group by job,second_year_mon,m
) b
on a.job=b.job and a.m=b.m
order by first_year_mon desc,job desc