select job,substr(date,1,7) as mon,
sum(num) as cnt
from resume_info
where year(date) =2025
group by job,substr(date,1,7)
order by mon desc,cnt desc

简单