你可能感兴趣的试题
SELECT Sname FROM S，SC，C WHERE S Sno=SC.Snn AND SC.Con=C.Con And Teacher='LTU' AND Seex='F' SELECT Sname FROM S WHERE Ssex='F' AND Sno IN (SELECT Sno FROM SC WHERE(Cno IN(SELECT Cno FROM C WHERE Teacher='LIU')) SELECT Sname FROM S WHERE Ssex='F' AND EXISTS(SELECT* FROM SC WHEPE SC.Sno=S. Sno AND EXISTS (SELECT* FROM C WHERE Teacher='LIU')) SELECT Sname FROM S WHEPE Ssex='F' AND EXISTS(SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT* FROM C WHERE C Cno=SC Cno AND Teacher='LIU'))
What’s your English teacher like How is your English teacher like What does your English teacher like What does your English teacher look like
A.what TV show does your English teacher like what TV show your English teacher likes what TV show did your English teacher like what TV show your English teacher liked
Mr. Liu was, who taught us English was Mr. Liu, who taught us English was who taught us English, Mr. Liu Mr. Liu, who taught us English, was
Mr. Liu was, who taught us English was Mr. Liu, who taught us English was who taught us English, Mr. Liu Mr. Liu, who taught us English, was
so Liu Xiang does so is Liu Xiang so does Liu Xiang so Liu Xiang is
SELECT Sname FROM S，SC，C WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS( SELECT * FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT * FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS( SELECT * FROM SC WHERE SC Sno=S Sno AND EXISTS (SELECT * FROM C WHERE C.Cno=SC.Cno AND Teacher=‘LIU’))
SELECT Sname FROM S，SC，C WHERE Sno=SSno AND SCno=Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS (SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS(SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Cno=SCno AND Teacher=‘LIU’))
enter the teacher of English and head teacher enters the teacher of English and head teacher does the teacher of English and head teacher the teacher of English and head teacher enter
湘公网安备 43130202000226号