Consider the following table schemas (primary keys are underlined): Book (BookId, Title, Publishername) Book_Authors (BookId, AuthorName) Publisher (Name, Address, Phone) Book_Copies (BookId, BranchId, No_Of_Copies) Book_Loans (BookId, BranchId, CardNo, DateOut, DueDate) Library_Branch (BranchId, BranchName, Address) Borrower (CardNo, Name, Address, Phone) Write SQL statements for the following queries: List the names and addresses of all borrowers who have borrowed more than 5 books that are published by “ABC”. List the names and addresses of all borrowers who have borrowed more than 5 books that are published by “ABC”.

Answer rating: 100% (QA)

SELECT BorrowerName BorrowerAddress FROM ... View the full answer