查询“001”课程比“002”课程成绩高的所有学生的学号

select a.S# from (select s#,score from SC where C#=’001’) a,(select s#,score from SC where C#=’002’) b where a.score>b.score and a.s#=b.s#;