select 
r1.job
,first_year_mon
,first_year_cnt
,second_year_mon
,second_year_cnt
from 
(
    select 
    job
    ,left(date,7) first_year_mon
    ,sum(num) first_year_cnt
    from resume_info 
    where date like '2025%'
    group by job,first_year_mon
) r1 join 
(
    select 
    job
    ,left(date,7) second_year_mon
    ,sum(num) second_year_cnt
    from resume_info 
    where date like '2026%'
    group by job,second_year_mon
) r2 on r1.job=r2.job
where right(r1.first_year_mon,2)=right(r2.second_year_mon,2)
order by first_year_mon desc,job desc

思路：将2025和2026年的分别用俩个子查询查出，连接条件用 job ，外层条件为月份相等。