描述 分组计数每日简历总数 考点 日期范围限定:BETWEN AND 最快in 数字比 in 字符 快 SELECT job, SUM(num) cnt FROM resume_info # 最快 WHERE date BETWEEN '2025-01-01' AND '2025-12-31' # 直接写数字会比字符执行快 # WHERE year(date) = 2025 # WHERE year(date) = ‘2025’ GROUP BY job ORDER BY cnt DESC;