select job,sum(num) as cnt from resume_info
where date between '2025-01-01' and '2025-12-31'
group by job
order by cnt desc;

like '2025%'
或
year(date) = 2025
或
between '2025-01-01' and '2025-12-31'
或
date >= '2025-01-01' and date <= '2025-12-31'