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