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