题解 | #实习广场投递简历分析(一)#

这个题只要是考察怎么提取日期数据

-- 解法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