1.分析
sum不是count
LIKE运算符用于WHERE表达式中，以搜索匹配字段中的指定内容

2.代码

SELECT job, sum(num) as cnt
from resume_info
WHERE date LIKE '2025%'
GROUP BY job
ORDER BY cnt DESC