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

select
    job,
    concat (year (date), '-', LPAD(MONTH(date), 2, '0')) as mon,
    sum(num) as cnt
from
    resume_info
where year(date) = 2025
group by
    job,
    mon
order by
    mon desc,
    cnt desc