select job, sum(num) as cnt
from resume_info
where left(date, 4) = '2025'
group by job
order by sum(num) desc;

或者：where date like '2025%'
where YEAR(date)=2025（'2025'）
where left(date, 4) = 2025