单项选择题

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

A.SELECT Sname<br> FROM S,SC,C<br> WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher='LIU' AND Ssex='F'
B.SELECT Sname<br> FROM S WHERE Ssex='F' AND Sno IN<br> (SELECT Sno<br> FROM SC<br> WHERE Cno IN (SELECT Cno FROM C<br> WHERE Teacher='LIU'))
C.SELECT Sname<br> FROM S WHERE Ssex='F' AND EXISTS(SELECT *<br> FROM SC<br> WHERE SC.Sno=S.Sno AND EXISTS<br> (SELECT *<br> FROMC<br> WHERE Teacher='LIU'))
D.SELECT Sname<br> FROM S WHERE Ssex='F' AND EXISTS (SELECT *<br> FROM SC<br> WHERE SC.Sno=S.Sno AND EXISTS<br> (SELECT *<br> FROM C<br> WHERE C.Cno=SC.Cno AND Teacher='LIU'))