题解 | #考试分数(一)#
考试分数(一)
https://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
select job, round(avg(score),3) avg from grade group by job order by avg desc
- 考察聚合函数的使用
考试分数(一)
https://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
select job, round(avg(score),3) avg from grade group by job order by avg desc
相关推荐