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

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