40)查找学生姓名及其所选修课程的课程号和成绩,正确的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