题解 | #考试分数(一)#
考试分数(一)
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
相关推荐