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

select a.job,
a.date as first_yera_mon,
a.cnt as first_year_cnt,
b.date as second_year_mon,
b.cnt as second_year_cnt
from 
(select distinct job, date_format(date,'%Y-%m') as date, month(date)as mon, sum(num)over(partition by date_format(date,'%Y-%m'),job) as cnt
from resume_info 
where year(date)='2025') a
left join 
(select distinct job, date_format(date,'%Y-%m') as date, month(date)as mon, sum(num)over(partition by date_format(date,'%Y-%m'),job) as cnt
from resume_info 
where year(date)='2026') b
on a.job=b.job and a.mon=b.mon
order by 2 desc, 1 desc