select
distinct job,
substr(date,1,7) mon,
sum(num)over(partition by substr(date,1,7),job)
from resume_info
where substr(date,1,4)='2025'
order by 2 desc,3 desc