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