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

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

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

C．） SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.c

no=course.cno

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