题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
求和用sum(),年份用year(date)
select job,sum(num) cnt
from resume_info
where year(date) ='2025'
group by job
order by cnt desc
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
求和用sum(),年份用year(date)
select job,sum(num) cnt
from resume_info
where year(date) ='2025'
group by job
order by cnt desc
相关推荐
查看14道真题和解析