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

select
    a.job,
    a.first_year_mon,
    a.first_year_cnt,
    b.second_year_mon,
    b.second_year_cnt
from
    (
        select job,
               date_format(date, "%Y-%m") as first_year_mon,
               sum(num) as first_year_cnt
        from resume_info
        where year(date) = 2025
        group by
            job,
            first_year_mon
    ) a
    left join (
        select
            job,
            date_format(date, "%Y-%m") as second_year_mon,
            sum(num) as second_year_cnt
        from resume_info
        where
            year(date) = 2026
        group by
            job,
            second_year_mon
    ) b on a.job = b.job and right(a.first_year_mon,2)=right(b.second_year_mon,2)
    order by a.first_year_mon desc, a.job desc;