(40)查找学生姓名及其所选修课程号和成绩,正确的 SQL 语句是 A)SELECT sname FROM student, SEL
(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