题目描述:写出SQL语句查询在2025年内投递简历的岗位和数量,并且按数量降序排序。
select job,sum(num)as cnt from resume_info where year(date)="2025" group by job order by cnt desc
题目描述:写出SQL语句查询在2025年内投递简历的岗位和数量,并且按数量降序排序。
select job,sum(num)as cnt from resume_info where year(date)="2025" group by job order by cnt desc