select job
,date_format(date,'%Y-%m') mon
,sum(num) cnt
from resume_info
where year(date) = 2025
group by mon,job
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 mon,job
order by mon desc, cnt desc