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

with fir as(
    select job,left(date,7) mon1,month(date) m1,sum(num) s1
    from resume_info
    where year(date)='2025'
    group by job,mon1,m1
),sec as(
    select job,left(date,7) mon2,month(date) m2,sum(num) s2
    from resume_info
    where year(date)='2026'
    group by job,mon2,m2
)
select fir.job,mon1,s1,mon2,s2
from fir join sec on fir.job=sec.job and fir.m1=sec.m2
order by m1 desc,fir.job desc;