数据库编程第二章课后作业

---

#第三题
SELECT bName,bid,author,pubComp,price 
FROM book WHERE bid NOT IN(
SELECT nif FROM boorrow)

#第四题
SELECT r.rName,b.bName,p.pData,p.amount FROM penalty p 
INNER JOIN reader r ON r.rid=p.rid
INNER JOIN book b ON b.bid = p.rid


#第五题
SELECT b.rid,b.willData,b.returnData,r.rName,k.bName FROM boorrow b 
INNER JOIN reader r ON r.rid=b.rid
INNER JOIN book k ON k.bid=b.nif
WHERE b.rid IN(SELECT rid FROM reader r WHERE r.rAddress IS NULL) 
ORDER BY b.willData DESC,b.rid DESC