查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是
A.SELECT sname FROM student,SELECT cno,grade FROM sc WHERE studensno=ssno
B.SELECT sname,cno,grade FROM student,course WHERE studensno=courscno
C.SELECT sname,cname,grade FROM student,course,sc WHERE studensno=ssno and scno=course,cno
D.SELECT sname,cno,grade FROM student,sc WHERE studensno=ssno