查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是

A．SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.sno

B．SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cno

C．SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cno

D．SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno