-- 16、检索"01"课程分数小于60,按分数降序排列的学生信息(和34题重复,不重点)
SELECT student.*,score.s_score FROM
student
INNER JOIN
score ON student.s_id=score.s_id
WHERE score.s_score<60 and score.c_id='01'
ORDER BY score.s_score DESC
-- 16、检索"01"课程分数小于60,按分数降序排列的学生信息(和34题重复,不重点)
SELECT student.*,score.s_score FROM
student
INNER JOIN
score ON student.s_id=score.s_id
WHERE score.s_score<60
GROUP BY score.c_id HAVING score.c_id='01'
ORDER BY score.s_score DESC
运行结果不同为什么呢