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

with t1 as(
    select job,date_format(date,'%Y-%m') as mon,month(date) as m,sum(num) as cnt
    from resume_info
    where year(date)=2025
    group by job,mon,m
),
t2 as(
    select job,date_format(date,'%Y-%m') as mon,month(date) as m,sum(num) as cnt
    from resume_info
    where year(date)=2026
    group by job,mon,m
)
select t1.job as job,t1.mon as first_year_mon,t1.cnt as first_year_cnt,t2.mon as second_year_mon,t2.cnt as second_year_cnt
from t1
join t2 on t1.job = t2.job 
AND t1.m=t2.m
order by first_year_mon DESC,job DESC