select job,date_format(date,'%Y-%m') mon,sum(num) count
from resume_info
where date>'2025-01-01' and date<'2025-12-31'
group by mon,job
order by mon desc,sum(num) desc