有以下四张表：
学生表Student(S#,Sname,Sage,Ssex)
课程表 Course(C#,Cname,T#)
成绩表 SC(S#,C#,score)
教师表 Teacher(T#,Tname)
1)查询“001”课程比“002”课程成绩高的所有学生的学号；
这题该怎么做

SELECT a.S#
FROM
(SELECT S#, score AS score_001 FROM SC WHERE C# = '001') a
JOIN
(SELECT S#, score AS score_002 FROM SC WHERE C
# = '002') b ON a.S#
= b.S#
WHERE a.score_001 > b.score_002;