select
distinct t1.job,t1.first_yeat_mom,t1.ct1,t2.second_yeat_mom,t2.ct2
from (select
distinct job,date,
substr(date,1,7) first_yeat_mom,
sum(num)over(partition by substr(date,1,7),job) ct1
from resume_info
where substr(date,1,4)='2025'
) t1
left join 
(select
distinct job,
substr(date,1,7) second_yeat_mom,
sum(num)over(partition by substr(date,1,7),job) ct2
from resume_info
where substr(date,1,4)='2026'
) t2
on t1.job = t2.job 
and t2.second_yeat_mom = substr(DATE_ADD(t1.date,INTERVAL 1 YEAR),1,7)
order by 2 desc,1 desc