题解 | 实习广场投递简历分析(二)

select
    job,
    date_format(date,'%Y-%m') as mon,
    sum(num) as cnt
from
    resume_info
where
    date_format(date,'%Y')=2025
group by
    job,
    mon
order by
    mon desc,
    cnt desc