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; # 记得进行年份筛选!