with a as ( select job, substring(date, 1, 7) as mon, sum(num) as cnt from resume_info where substring(date, 1, 4) in ('2025', '2026') group by job, mon ) select a1.job as job, a1.mon as first_year_mon, a1.cnt as first_year_cnt, a2.mon as second_year_mon, a2.cnt as second_year_cnt from a a1 join a a...
