For each book title with more than 3 copies, list the names of library members who have borrowed them.
What will be an ideal response?
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);
Computer Science & Information Technology
You might also like to view...
PowerPoint templates are stored in the same default location as PowerPoint presentations
Indicate whether the statement is true or false
Computer Science & Information Technology
Could the gossip architecture be used for a distributed computer game ?
What will be an ideal response?
Computer Science & Information Technology