查询学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是( )。
A.SELECT S SNAME,SC.C#,GRADE FROM S WHERE S S#=SC.S#
B.SELECT S.SNAME,SC.C#,GRADE FROM SC WHRES S==SC.S#
C.SELECT S SNAME,SC.C#,GRADE FROM S.SC WHERE S.S#=SC.S#
D.SELECT S.SNAME.SC.C#,GRADE FROM S.SC WHERE SS#=SC.C#