select job,
concat('2025-',date_format(date, '%m')) first_year,
sum(case when year(date)=2025 then num else 0 end) first_cnt,
concat('2026-',date_format(date, '%m')) second_year,
sum(case when year(date)=2026 then num else 0 end) second_cnt
from resume_info
group by job, date_format(date, '%m')
order by first_year desc, job desc