题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
SELECT DISTINCT job, SUM(num) over(PARTITION BY job) "cnt" FROM resume_info WHERE YEAR(DATE) = "2025" ORDER BY cnt DESC
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
SELECT DISTINCT job, SUM(num) over(PARTITION BY job) "cnt" FROM resume_info WHERE YEAR(DATE) = "2025" ORDER BY cnt DESC
相关推荐