题目内容:
现有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=’王华。
参考答案:【答案仅供学习,请勿对照自行用药等】
答案解析: