select job, sum(num) cnt
from resume_info
where date_format(date,'%Y')<=2025
group by job
order by cnt desc
  • 利用groupby和聚合函数得到结果
  • 使用date_format筛选年份