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