已知选课关系SC(S# char(8), C# char(8), GRADE integer),S#学号,C#课程号,GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是_________。
A.
SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SC WHERE C#='C2')
B.
SELECT S# FROM SC WHERE C#='C2' AND GRADE >= ALL(SELECT GRADE FROM SC WHERE C#='C2')
C.
SELECT S# FROM SC WHERE C#='C2' AND GRADE >=(SELECT GRADE FROM SC WHERE C#='C2')
D.
SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2')