WHERE StdID IN (SELECT StdID FROM Lend WHERE BookID IN (SELECT BookID FROM Book WHERE Title='数据结构') ) 答案二：SELECT Name,StdID FROM Student,Lend,Book WHERE Student.ID=Lend.StdID AND Book.BookID=Lend.BookID AND Title='数据结构'； 四、（本题10分） 答： SELECT S.SN FROM S,SP,P WHERE S.SNO-SP.SNO AND P.PNO=SP.PNO AND P.PN='TV'; 五、（每小题8分，共16分） 答： R✉S为 A B C D 1 2 3 4 1 2 3 7 6 7 8 6 9 7 e 6 R☒RB≠s.BS为 440W HERE StdID IN (SELECT StdID FROM Lend WHERE BookID IN (SELECT BookID FROM Book WHERE Title=‘数据结构‘) ); 答案二 :SELECT Name, StdID FROM Student, Lend, Book W HERE Student. ID二Lend. StdID AND Book. BookID=Lend. BookID AND Title=’数据结构‘; 四、(本题 10分) 答 : 一SELECT S.SN FROM S, SP, P W HERE S. SNO二SP. SNO AND P. PNO= SP. PNO AND P. PN二‘TV'; 五 、(每小题 8分，共 16分) 答 : Rp<S为 A B C D 1 2 3 4 1 2 3 7 6 7 8 6 9 7 8 6 R Daa. Bas. s S为 440