查找学生姓名及其所选修课程的课程号和成绩，正确的SQL语句是【 】。
A．SELECT sname FROM student，SELECT cno，grade FROM SC WHERE student.sno=SC.sno
B．SELECT sname，cno，grade FROMstudent，course WHEREstudent.sno=course.Cno
C．SELECT sname，cname，grade FROMstudent，course，SC WHEREstudent.sno=SC.snoandSC.cno=course，cno
D．SELECT sname，cno，grade FROMstudent，SC WHEREstudent.sno=sc.sno