没啥好说的用个通配符就好了

select job,sum(num) as cnt 
FROM resume_info
WHERE date LIKE "2025%"
GROUP BY job
ORDER BY sum(num) desc