题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
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 
