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