c语言sno是什么缩写,对于教学数据库的三个基本表:S(Sno,Sname,Ssex),SC(Sno,Cno,Grade),C(Cno,Cname, Teacher), - 赏学吧...

时间:2025-02-10 07:03:05

对于教学数据库的三个基本表:S(Sno,Sname,Ssex),SC(Sno,Cno,Grade),C(Cno,Cname, Teacher),其中S为学生表,SC为学生选课表,C为课程表,则对于语句:检索至少选修LIU老师所授课课程中一门课程的女生姓名,SQL语句错误的是______。

A) SELECT Sname

FROM S,SC,C

WHERE = AND = AND Teacher=‘LIU’AND Ssex=‘F’

B) SELECT Sname

FROM S WHERE Ssex=‘F’AND Sno IN

(SELECT Sno

FROM SC

WHERE Cno IN(SELECT Cno FROM C

WHERE Teacher=‘LIU’))

C) SELECT Sname

FROM S WHERE Ssex=‘F’AND EXISTS (SELECT*

FROM SC

WHERE = AND EXISTS

(SELECT*

FROM C

WHERE Teacher=‘LIU’))

D) SELECT Sname

FROM S WHERE Ssex=‘F’AND EXISTS(SELECT*

FROM SC

WHERE = AND EXISTS

(SELECT*

FROM C

WHERE = AND Teacher=‘LIU’))