Consider the following table schemas (primary keys are underlined): Book (BookId, Title, Publishername) Book_Authors (BookId, AuthorName) Publisher
Fantastic news! We've Found the answer you've been seeking!
Question:
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”.
Related Book For
Posted Date: