查询“01“课程比“02“课程成绩高的学生的信息及课程分数

select test.c.S_no,test.student.s_name,test.c.c_no,test.c.S_score
from test.score c,test.student
where test.c.s_no=test.student.s_no and test.c.S_no in (select a.s_no from (select test.score.S_no,test.score.C_no,test.score.S_score from test.score where test.score.c_no='01')a, (select test.score.S_no,test.score.C_no,test.score.S_score from test.score where test.score.c_no='02')b 
where a.s_score>b.s_score and a.s_no=b.s_no)