题目描述:写出SQL语句查询在2025年内投递简历的岗位和数量,并且按数量降序排序。

select job,sum(num)as cnt
from resume_info
where year(date)="2025"
group by job
order by cnt desc