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

with t as(

SELECT distinct job

    ,date_format(date,"%Y-%m") as date

    ,date_format(date,"%m") as m

    ,date_format(date,"%Y") as y

    ,sum(num)over(partition by job,date_format(date,"%Y-%m")) cnt

FROM resume_info    

where year(date) in (2025,2026)

)

select t1.job,t1.date,t1.cnt,t2.date,t2.cnt

from t t1

join t t2

on t1.job =t2.job

and t1.m=t2.m

and t1.y<t2.y

order by t1.date desc,t1.job desc