相连的两表选取的年份不同，其他部分不变，创建临时表方便修改和阅读

with as 创建临时表

WITH 
r1 AS
(
SELECT id, job, date, DATE_FORMAT(date, '%Y-%m') AS first_year_mon, SUM(num) AS first_year_cnt
FROM resume_info
WHERE date LIKE '2025%'
GROUP BY job, first_year_mon
),
r2 AS
(
SELECT id, job, date, DATE_FORMAT(date, '%Y-%m') AS second_year_mon, SUM(num) AS second_year_cnt
FROM resume_info
WHERE date LIKE '2026%'
GROUP BY job, second_year_mon
)

两表相连

SELECT r1.job,
first_year_mon,
first_year_cnt,
second_year_mon,
second_year_cnt
FROM r1 , r2 
WHERE r1.job = r2.job AND DATE_FORMAT(r1.date, '%m') = DATE_FORMAT(r2.date, '%m')
ORDER BY first_year_mon DESC, r1.job DESC