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_cntfrom resume_infogroup by job, da...