select job,left(date,7) as mon,
sum(num) as cnt
from resume_info
where left(date,4) = '2025'
group by job,mon
order by mon desc,cnt desc;
select job,left(date,7) as mon,
sum(num) as cnt
from resume_info
where left(date,4) = '2025'
group by job,mon
order by mon desc,cnt desc;