现有3个表Students(SID,SN,SEX,AGE,DEPT),Courses(CID,CNAME),SCORE(SID,CID,GRADE)。 其中,SID为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,CID为课程号,CNAME为课程 名,GRADE为成绩。检索“”同学所选修的课程名称和成绩,正确的SELECT语句是( )。
A.
SELECT CNAME,GRADE FROM Students INNER JOIN SCORE ON Students.SID=SCORE.SID INNER JOIN Courses ON SCORE.CID=Courses.CID WHERE SN=’’
B.
SELECT CNAME,GRADE FROM Students INNER JOIN Courses ON Students.SID=Courses.CID WHERE SN=’’
C.
SELECT CNAME,GRADE FROM SCORE INNER JOIN Courses ON SCORE.CID=Courses.CID WHERE CNAME=。。
D.
SELECT CNAME,GRADE FROM Students INNER JOIN Courses ON Students.SN=Courses.CNAME WHERE SN=’。