select f.job,f.mon first_year_mon,f.cnt first_year_cnt,
s.mon second_year_mon,s.cnt second_year_cnt
from (select job,left(date,7) mon,sum(num) cnt
from resume_info
where year(date) = '2025'
group by job,mon) f
join
(select job,left(date,7) mon,sum(num) cnt
from resume_info
where year(date) = '2026'
group by job,mon) s
on f.job = s.job and right(f.mon, 2) = right(s.mon, 2)
order by first_year_mon desc,job desc;