SQL面试50题-16
题目链接：https://zhuanlan.zhihu.com/p/43289968
16、检索"01"课程分数小于60，按分数降序排列的学生信息（和34题重复，不重点）
1.'01'课程分数
SELECT s_score FROM Score WHERE c_id = '01'
2.课程分数＜60
SELECT s_score FROM Score WHERE s_score < 60
完整代码：
SELECT a.s_id,a.s_name,b.s_score FROM Student a INNER JOIN Score b ON a.s_id = b.s_id WHERE b.c_id = '01' AND b.s_score < 60 ORDER BY b.s_score DESC;