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

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