select
    t1.job,
    concat('2025-',t1.mon) as mon,
    sum(t1.num) as cnt
from
(select
    job,
    num,
    substr(date,6,2) as mon
from resume_info
where date like '2025%') t1
group by t1.job,t1.mon
order by t1.mon desc,sum(t1.num) desc