题解 | #考试分数(一)#
考试分数(一)
https://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
SELECT job, ROUND(AVG(score),3) AS avg FROM grade GROUP BY job ORDER BY avg DESC
考试分数(一)
https://www.nowcoder.com/practice/f41b94b4efce4b76b27dd36433abe398
SELECT job, ROUND(AVG(score),3) AS avg FROM grade GROUP BY job ORDER BY avg DESC
相关推荐