题解 | # DATE_FORMAT()函数
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
SELECT job, date_format(date,'%Y-%m') AS mon,
SUM(num) AS cnt
FROM resume_info ri
WHERE YEAR(date) = '2025'
GROUP BY job, mon
ORDER BY mon DESC, cnt DESC
投递百度等公司10个岗位
