题解 | #考试分数(一)#
考试分数(一)
http://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
知识点
1.按照job进行分组,计算平均值avg,round取三位小数,最后按照avg降序排序
代码
select job, round(avg(score),3) as avg
from grade
group by job
order by avg desc
考试分数(一)
http://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
1.按照job进行分组,计算平均值avg,round取三位小数,最后按照avg降序排序
select job, round(avg(score),3) as avg
from grade
group by job
order by avg desc
相关推荐