select job, sum(num) cnt from resume_info where year(date) = '2025' group by job order by cnt desc
本题 难点: 1、分组计算 group by job, 只有分好组才能对 同组下的 数值进行聚合运算 ( sum( ) )
2、时间函数, year(date)、month(date)&day(date))--获取年、月、日的函数。 所以此处用 year(date) = '2025'
3、排序降率; order by 字段 desc