限定为某一年内时，按'年+月'分组去重与按'月'分组去重一样

select t1.job 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,date_format(date,'%m') fd
from resume_info
where date like '2025%'
group by first_year_mon,job,fd) t1
join
(select job,date_format(date,'%Y-%m') second_year_mon,sum(num) second_year_cnt,date_format(date,'%m') fd
from resume_info
where date like '2026%'
group by second_year_mon,job,fd) t2 
on t1.fd=t2.fd and t1.job=t2.job
order by first_year_mon desc,job desc