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