– 查询每门课程的平均成绩,结果按平均成绩降序排列,平均成绩相同时,按课程编号升序排列
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
– 查询每门课程的平均成绩,结果按平均成绩降序排列,平均成绩相同时,按课程编号升序排列
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