题解 | 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; 

# 记得进行年份筛选！