题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
https://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
#1 select distinct job, sum(num)over(partition by job) as cnt from resume_info where year(date)='2025' order by cnt desc #2 select job , sum(num)as cnt from resume_info where year(date)='2025' group by job order by cnt desc