考察date_format，同时也考察了按照月份、工作进行分组。

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