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