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

或者时间限制写法改成：
datediff(date,"2025-10-15")>0