思路:分别查询后连接,用字符串方法连接，第一年的年+1 = 第二年的年,第一年的月 = 第二年的月
select
a.job
,first_year_mon
,first_year_cnt
,second_year_mon
,second_year_cnt
from
(
select
job
,date_format(date,'%Y-%m') first_year_mon
,sum(num) first_year_cnt
from resume_info
where year(date) = '2025'
group by 1,2
) a
left join
(
select
job
,date_format(date,'%Y-%m') second_year_mon
,sum(num) second_year_cnt
from resume_info
where year(date) = '2026'
group by 1,2
) b
on substring(a.first_year_mon,1,4) + 1 = substring(b.second_year_mon,1,4)
and a.job = b.job
order by first_year_mon desc,a.job desc