![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
已知关系S(S#,SN,AGE,SEX),SC(C#,S#,GRADE),C(C#,CN,TEACHER)。若要检索学生姓名及其选修课程的课程号和成绩,正确的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
D.
SELECT S.SN,SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#