For each book title with more than 3 copies, list the names of library members who have borrowed them.

Question

What will be an ideal response?

Answer 1

SELECT title, borrowerName
FROM Borrower bw, Book b, BookCopy bc, BookLoan bl
WHERE bw.borrowerNo = bl.borrowerNo AND bl.copyNo = bc.copyNo
AND bc.ISBN = b.ISBN AND EXISTS
(SELECT ISBN, COUNT(bc1.copyNo)
FROM BookCopy bc1
WHERE bc1.ISBN = bc.ISBN
GROUP BY bc1.ISBN
HAVING COUNT(bc1.copyNo) > 3);