题解 | #牛客每个人最近的登录日期(五)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
SELECT job, LEFT(date, 7) AS mon, SUM(num) AS cnt
FROM resume_info
WHERE date BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY job, MONTH(date)
ORDER BY MONTH(date) DESC, SUM(num) DESC;
代码已通过~取年月也可以用left函数，截取7位就行
投递平安人寿等公司10个岗位
浩鲸科技二面10人在聊