分别提取2025年和2026年的数据，再join起来，用到截取字符串left(s,n)和right(s,n)

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,
        sum(num) as first_year_cnt 
from resume_info
where date like '2025%'
group by job,first_year_mon
order by first_year_mon desc,job desc) as a 
join 
(select job,
        left(date,7) as second_year_mon,
        sum(num) as second_year_cnt 
from resume_info
where date like '2026%'
group by job,second_year_mon
order by second_year_mon desc,job desc) as b
on a.job = b.job
and right(first_year_mon,2) = right(second_year_mon,2);