• 参考答案
select job,
  left(date,7) as 'mon', 
  sum(num) as 'cnt' from resume_info ri1
where date between '2025-01-01' and '2026-01-01'
group by job,mon
order by mon desc,cnt desc
  • 答案解析
    本题难点在于同时对job和cnt的分组与排序的理解
    还有字符串的切割left(date,7)
group by job,mon
order by mon desc,cnt desc