题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
SELECT b.job,b.mon,SUM(b.num) AS cnt
FROM (
SELECT a.*,substr(date, 1,7) AS mon
FROM resume_info AS a
WHERE a.date>='2025-01-01' AND a.date<='2025-12-31'
) AS b
GROUP BY b.job,b.mon
ORDER BY b.mon DESC,cnt DESC
快手公司福利 352人发布