2 查询没有借阅信息的读者编号和姓名
SELECT reader.rid,reader.rName FROM reader
where NOT EXISTS(
SELECT * FROM borrow WHERE reader.rid=borrow.rid
)
3 到今天为止应还书但还未还书的信息
SELECT reader.rid,reader.rName,book.bid,book.bName,willDate FROM borrow
INNER JOIN reader ON borrow.rid=reader.rid
INNER JOIN book ON borrow.nif=book.bid
WHERE returnDate is NULL
4 查询各种图书未借出的本数,及书名和本数
SELECT bName,bCount FROM book
WHERE NOT EXISTS
(SELECT * FROM borrow WHERE borrow.nif=book.bid)
5 从已完成借阅的记录中,统计每位读者的借书次数,显示读者姓名和借书次数
SELECT reader.rid,reader.rName as '读者姓名',COUNT(nif)as '借书次数' FROM borrow
INNER JOIN reader ON reader.rid=borrow.rid
WHERE borrow.returnDate IS NOT NULL
GROUP BY rid
6 查询总罚款金额大于5元的读者姓名和总罚款金额
SELECT reader.rid,reader.rName,amoun