先找到2025年内各月的职位投递数量总和，然后寻找对应的下一年当月的投递数量之和

SELECT b.job,b.mon AS first_year_mon,SUM(b.num) AS first_year_cnt,substr(DATE(b.date,'+1 year'),1,7) AS second_year_mon,
(
SELECT SUM(c.num)
FROM resume_info AS c
WHERE c.job=b.job AND substr(c.date,1,7)=substr(DATE(b.date,'+1 year'),1,7)
) AS second_year_cnt
FROM (
SELECT a.*,substr(date, 1,7) AS mon
FROM resume_info AS a
WHERE a.date>='2025-01-01' AND a.date<='2025-12-31'
) AS b
GROUP BY b.job,b.mon
ORDER BY first_year_mon DESC,b.job DESC