检索“01”课程分数小于60，按照分数降序排列的学生信息

select test.student.*,test.score.s_score from test.student, test.score
where test.student.s_no=test.score.s_no and

 test.score.s_no not in (select test.score.s_no from test.score where test.score.c_no='01' and test.score.s_score>60)
order by test.score.s_no,test.score.s_score desc