选取月份补0方法：

right(100+month(选取的月份）,2)

select job, concat(year(date),'-',right(100+month(date),2)) as mon, sum(num) as cnt
from resume_info
where year(date)=2025
group by job,mon
order by mon desc,cnt desc