select job,sum(num) cnt
from resume_info
三种办法
where date < "2026-01-01" and date >= "2025-01-01"
where year(date) = "2025"
where date like '2025%'
group by job
order by cnt desc;