SQL 72) 查询各个岗位分数的平均数
考试分数(一)
http://www.nowcoder.com/questionTerminal/f41b94b4efce4b76b27dd36433abe398
方法)分组求平均值
SELECT job, ROUND(AVG(score),3) AS avg FROM grade GROUP BY job ORDER BY avg DESC;
SQL 文章被收录于专栏
SQL
考试分数(一)
http://www.nowcoder.com/questionTerminal/f41b94b4efce4b76b27dd36433abe398
方法)分组求平均值
SELECT job, ROUND(AVG(score),3) AS avg FROM grade GROUP BY job ORDER BY avg DESC;
SQL
相关推荐