select job,date_format(`date`,'%Y-%m') mon,sum(num)cnt
from resume_info
where year(`date`)=2025
group by date_format(`date`,'%Y-%m'),job
order by date_format(`date`,'%Y-%m')desc,cnt desc