题解 | #实习广场投递简历分析(一)#

本题是一道简单题，首先要搞清楚题目的限制条件：

• 时间限制：2025年,可用函数提取年份year(date)='2025',date_format(date,'%Y')='2025'
• 岗位投递数量和：按Job group by,进行求和

  -- 解法一
  SELECT job,
    sum(num) AS cnt
  FROM resume_info
  WHERE year(date) = '2025'
  GROUP BY job
  ORDER BY cnt

  -- 解法二
  SELECT job,
    sum(num) AS cnt
  FROM resume_info
  WHERE date_format(date,'%Y') = '2025'
  GROUP BY job
  ORDER BY cnt

  欢迎小伙伴留言讨论~