题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
https://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
select job,sum(num) as cnt from resume_info where year(date)=2025 group by job order by cnt desc
1.首先限定条件 2025年内投递简历的岗位和数量，
where year(date)=2025
2.对岗位进行分组求和
select job,sum(num) as cnt from resume_info where year(date)=2025
group by job
3.最后以岗位数量降序排序
order by cnt desc
综合，select job,sum(num) as cnt from resume_info where year(date)=2025
group by job
order by cnt desc
