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

select
    a.job,
    a.mon fmon,
    a.cnt fcnt,
    b.mon smon,
    b.cnt scnt
from
    (
        select
            job,
            date_format (date, '%Y-%m') mon,
            sum(num) cnt
        from
            resume_info
        where
            substring(date, 1, 4) = '2025'
        group by
            job,
            mon
    ) a,
    (
        select
            job,
            date_format (date, '%Y-%m') mon,
            sum(num) cnt
        from
            resume_info
        where
            substring(date, 1, 4) = '2026'
        group by
            job,
            mon
    ) b
where
    a.job = b.job and right(a.mon,2)=right(b.mon,2)
    
order by
    fmon desc,
    job desc