需要注意的是比如date_sub("2021-01",interval 1 year) 是没用的

select t1.job ,t1.first_year_mon , t1.first_year_cnt , t2.second_year_mon,t2.second_year_cnt from

(select job,date_format(date,'%Y-%m') as first_year_mon, sum(num) as first_year_cnt from resume_info where year(date)=2025 group by job,date_format(date,'%Y-%m'))t1

join

(select job,date_format(date,'%Y-%m') as second_year_mon, sum(num) as second_year_cnt from resume_info where year(date)=2026 group by job,date_format(date,'%Y-%m'))t2

on right(t1.first_year_mon,2)=right(t2.second_year_mon,2) and t1.job=t2.job

order by first_year_mon desc , job desc