select job,date_format(date,'%Y-%m')as mon,sum(num)as cnt
-- y是两位数25，Y才是四位数2025
from resume_info
where year(date)=2025
group by job,mon
order by mon desc,cnt desc;