题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
这个题只要是考察怎么提取日期数据
-- 解法1
SELECT job,
sum(num) AS cnt
FROM resume_info
WHERE year(date) = '2025'
GROUP BY job
ORDER BY cnt DESC
-- 解法2
SELECT job,
sum(num) AS cnt
FROM resume_info
WHERE date_format(date,'%Y') = '2025'
GROUP BY job
ORDER BY cnt DESC 
开发本科够了，早准备早投递
投递牛客等公司10个岗位 >
字节跳动公司氛围 548人发布