你不能像别人一样默认第二年为2026

WITH first_year AS (
    SELECT 
        job,
        SUM(num) AS first_year_cnt, 
        DATE_FORMAT(date, '%Y-%m') AS first_year_mon 
    FROM 
        resume_info
    WHERE 
        date LIKE '2025%'
    GROUP BY 
        job, first_year_mon
),

second_year AS (
    SELECT 
        r.job, 
        SUM(r.num) AS second_year_cnt,
        DATE_FORMAT(DATE_ADD(STR_TO_DATE(CONCAT(f.first_year_mon, '-01'), '%Y-%m-%d'), INTERVAL 1 YEAR), '%Y-%m') AS second_year_mon
    FROM 
        first_year f
    JOIN 
        resume_info r 
    ON 
        r.job = f.job 
        AND DATE_FORMAT(r.date, '%Y-%m') = DATE_FORMAT(DATE_ADD(STR_TO_DATE(CONCAT(f.first_year_mon, '-01'), '%Y-%m-%d'), INTERVAL 1 YEAR), '%Y-%m')
    GROUP BY 
        r.job, second_year_mon
)
SELECT 
    f.job, 
    f.first_year_mon, 
    f.first_year_cnt, 
    s.second_year_mon, 
    s.second_year_cnt
FROM 
    first_year f
JOIN 
    second_year s 
ON 
    f.job = s.job 
    AND f.first_year_mon = DATE_FORMAT(DATE_SUB(STR_TO_DATE(CONCAT(s.second_year_mon, '-01'), '%Y-%m-%d'), INTERVAL 1 YEAR), '%Y-%m')
ORDER BY 
    f.first_year_mon DESC, 
    f.job DESC;