select job, DATE_FORMAT(date, '%Y-%m') as mon, SUM(num) as cnt from resume_info where date between '2025-01-01' and '2025-12-31' group by job, mon order by mon desc, cnt desc;