模糊查找 like 通配符

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