题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
SELECT a.job,a.date, -- SUM(num) OVER(PARTITION BY job,date) AS cnt SUM(a.num) AS cnt FROM ( SELECT job,DATE_FORMAT(date,'%Y-%m') AS date,num FROM resume_info WHERE date >= '2025-01-01' AND date <= '2025-12-31' )a GROUP BY a.date,a.job ORDER BY a.date DESC,cnt DESC
