题解 | #实习广场投递简历分析(三)#

SELECT 
    resume_2025.*, 
    resume_2026.mon, 
    resume_2026.num
FROM 
(
    SELECT 
        job, 
        substr(date, 1, 7) AS mon,
        sum(num) AS num
    FROM 
        resume_info 
    WHERE 
        substr(date, 1, 4) = '2025'
    GROUP BY 
        job, substr(date, 1, 7)
) AS resume_2025 
LEFT OUTER JOIN 
(
    SELECT 
        job, 
        substr(date, 1, 7) AS mon,
        sum(num) AS num
    FROM 
        resume_info 
    WHERE 
        substr(date, 1, 4) = '2026'
    GROUP BY 
        job, substr(date, 1, 7)
) AS resume_2026 
ON 
    resume_2025.job = resume_2026.job
AND 
    SUBSTR(resume_2025.mon, 6,2)= SUBSTR(resume_2026.mon, 6,2)
ORDER BY 
    resume_2025.mon DESC , 
    resume_2025.job DESC