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