select
job,
max(if(left(date, 4) = '2025', date, 0)) first_year_mon,
max(if(left(date, 4) = '2025', cnt, 0)) first_year_cnt,
max(if(left(date, 4) = '2026', date, 0)) second_year_mon,
max(if(left(date, 4) = '2026', cnt, 0)) second_year_cnt
from (
select job, date_format(date, '%Y-%m') date, sum(num) cnt
from resume_info
group by job, date_format(date, '%Y-%m')) t
group by job, right(date, 2)
order by first_year_mon desc, job desc