• 参考答案
select job, sum(num) as 'cnt' from resume_info
where date between '2025-01-01' and '2026-01-01'
group by job
order by cnt desc

#  between  1 and 10    相当于>=1 <=10
#   between  '2017-5-16' and '2017-5-17 ' 则只查出 16号（左包含，右不包含）， 因为数据库默认2017-5-16 00：00:00--->2017-5-17 00：00:00,也就是16号这一天