select
a.job
,a.mon
,sum(a.num) r
from (
select
id
,job
,substring(date,1,7) mon
,num
from resume_info
where date >= '2025-01-01'
and date <= '2025-12-31'
) a
group by 1,2
order by a.mon desc,r desc