题解 | #实习广场投递简历分析(三)#
实习广场投递简历分析(三)
https://www.nowcoder.com/practice/83f84aa5c32b4cf5a75558d02dd7743c
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;
查看4道真题和解析
