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