with resume_info_month as (
    select 
        *,
        substr(date,1,7) as mon
    from 
        resume_info
    where 
        year(date) = 2025
)

select
    job,
    mon,
    sum(num) as cnt
from 
    resume_info_month
group by 
    job,mon
order by 
    mon desc,
    cnt desc