SELECT c.c_id,c.c_name,AVG(sc.s_score) FROM course c
INNER JOIN score sc ON sc.c_id=c.c_id
GROUP BY c.c_id ORDER BY AVG(sc.s_score) DESC,c.c_id ASC
-- 32、查询每门课程的平均成绩,结果按平均成绩降序排列,平均成绩相同时,按课程编号升序排列
最新推荐文章于 2022-10-08 22:02:12 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
SELECT c.c_id,c.c_name,AVG(sc.s_score) FROM course c
INNER JOIN score sc ON sc.c_id=c.c_id
GROUP BY c.c_id ORDER BY AVG(sc.s_score) DESC,c.c_id ASC