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