题解 | #考试分数(一)#
考试分数(一)
http://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
select job,round(avg(score),3)
from grade
group by job
order by round(avg(score),3) desc
考试分数(一)
http://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
select job,round(avg(score),3)
from grade
group by job
order by round(avg(score),3) desc
相关推荐