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

有个陷阱，看到cnt时下意识用count，实际应该用sum
时间可以用year()就可以