题解 | #实习广场投递简历分析(三)#
实习广场投递简历分析(三)
https://www.nowcoder.com/practice/83f84aa5c32b4cf5a75558d02dd7743c
select
y1.job,
first_year_mon,
first_year_cnt,
second_year_mon,
second_year_cnt
from (
select
job,
DATE_FORMAT(date,'%Y-%m') as first_year_mon,
sum(num) as first_year_cnt
from resume_info
where date like '2025%'
group by job,DATE_FORMAT(date,'%Y-%m')
) as y1
join (
select
job,
DATE_FORMAT(date,'%Y-%m') as second_year_mon,
sum(num) as second_year_cnt
from resume_info
where date like '2026%'
group by job,DATE_FORMAT(date,'%Y-%m')
) as y2
on y1.job = y2.job and right(first_year_mon,2)=right(second_year_mon,2)
order by first_year_mon desc, y1.job desc
