year(字段名） 可直接获取年份

select job, sum(num) as cnt
from resume_info
where year(date)=2025
group by job
order by cnt desc