【单选题】[单选题]有三张表:学生表S(Sno,Sname,Ssex,Sage,Sdept),课程表C(Cno,Cname),学生选课表SC(Sno,Cno,Grade)。其中,Sno为学号,Sname为姓名,Ssex为性别,Sage年龄,Sdept为系别, Cno为课程号,Cname为课程名, Grade为成绩。请问:查询学生姓名及其所选课程的课程号和成绩,正确的语句是( )
选项：

A:SELECT S.Sname,S
C:Cno,S
C:Grade FROM S WHERE S.Sno=S
C:Sno
B:SELECT S.Sname,S
C:Cno,S
C:Grade FROM SC WHERE S.Sno=S
C:Grade
C:SELECT S.Sname,S
C:Cno,S
C:Grade FROM S,SC WHERE S.Sno=S
C:Sno
D:SELECT S.Sname,S
C:Cno,S
C:Grade FROM S WHERE S. SC