已知关系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 S,SC WHERE S.S#=SC.S# C.SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE D.SELECT S.SN,SC.C#,SC.GRADE FROM S.SC