知识点

  1. 2025年可以是date小小于2026-01-01'可以是year(date) = 2025'
  2. 统计数量就是先按照岗位分组再用求和

代码

select job, 
sum(num) as cnt
from resume_info
where date < '2026-01-01'
group by job
order by cnt desc