已知关系S(S#,SN,AGE,SEX),SC(C#,S#,GRADE),C(C#,CN,TEACHER),SC(S#,SN,C#,CN,GRADE)。若要检索学生姓名及其选修课程的课程号和成绩,正确的SELECT语句是_________。
A.
SELECT S.SN,SC.C#,SC.GRADE FROM S WHERE S.S#=SC.S#
B.
SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE
C.
SELECT S.SN,SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#
D.
SELECT S.SN,SC.C#,SC.GRADE FROM S.SC