笔试面试 已知成绩Score表,学生表Student(具体字段如图所示),补全这段SQL,使得能够 查询"002"课程比"003"课程成绩高的学生的信息及课程分数(课程Id即CId) SELECT * FROM Student RIGHT JOIN ( SELECT tmp1.SId, grade1, grade2 from (SELECT SId, score as grade1 from Score where Score .CId = ‘002’) AS tmp1, (SELECT SId, score as grade2 from Score where Score .CId = ‘003’) AS tmp2 ) Relation on Student.SId = Relation .SId;