使用 SQL 语句完成下面的查询 1 查询借阅了清华大学出版社 出版的图书的读者编号、图书编号、借书 日期和归还日期。 2 查询同时借阅了 操作系统和高等数学 两本书的读者编号、借书日 期和归还日期。 3查询借书总价在 2000 元以上的读者编号、图书名称、借书日期。 4 查询被借次数最多的图书的图书号、图书名和被借次数。 5查询借阅了所有清华大学出版社 出版的图书的读者详细信息。

(1)

SELECT BorrowerID, BookID, BorrowDate, ReturnDate FROM BorrowRecord WHERE Publisher = '清华大学出版社';

(2)

SELECT BorrowerID, BorrowDate, ReturnDate FROM BorrowRecord WHERE BookName IN ('操作系统', '高等数学') GROUP BY BorrowerID, BorrowDate, ReturnDate HAVING COUNT(DISTINCT BookName) = 2;

(3)

SELECT BorrowerID, BookName, BorrowDate FROM BorrowRecord JOIN Book ON BorrowRecord.BookID = Book.BookID WHERE Book.Price * BorrowAmount >= 2000;

(4)

SELECT BookID, BookName, COUNT(*) AS BorrowTimes FROM BorrowRecord JOIN Book ON BorrowRecord.BookID = Book.BookID GROUP BY BookID, BookName ORDER BY BorrowTimes DESC LIMIT 1;

(5)

SELECT * FROM Borrower WHERE NOT EXISTS ( SELECT BookName FROM Book WHERE Publisher = '清华大学出版社' AND Book.BookID NOT IN ( SELECT BookID FROM BorrowRecord WHERE Borrower.BorrowerID = BorrowRecord.BorrowerID ) )