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’))

LiuXiangwasthefirstAsiantowinthemen\'s110mhurdles跳

对于教学数据库的三个基本表SSnoSnameSsexSCSnoCnoGradeCCnoCnameTe

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’))

ManyfamiliesintheU.S_______NationalGrandparentsDay

congratulate organize observe Contribute

LiuXianga21-year-oldChineseathletegotthegoldmedalo

AthensOlympic110mhurdlechampionLiuXiangfeltsorelie

Liu Juan’s grandparents 　　 (be) in Shanghai.

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库

Liu Juan’s grandparents (be) in Shanghai.

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库

Liu Juan’s grandparents 　　 (be) in Shanghai.