题解 | SQL284 实习广场投递简历分析(二)
WITH t1 AS ( SELECT job, SUBSTR(date,1,7) AS mon, num FROM resume_info WHERE SUBSTR(date,1,4) = '2025' ), t2 AS ( SELECT job, mon, sum(num) AS cnt FROM t1 GROUP BY job,mon ORDER BY mon DESC,cnt DESC ) SELECT * FROM t2; # 记得进行年份筛选！
海信集团二面10人在聊