Question: Library ( Library _ id , lib _ name, city, address ) Book ( Book _ id , book _ title, book _ genre, publication
Library Libraryid libname, city, addressBook Bookid booktitle, bookgenre, publicationyear, authid libidFK libid references LibraryFK authid references AuthorAuthor Authid authname, authbirthyear, countryMember Memid memname, memjoindate, cityLoan Loanid bookid memid loandate, returndateFK bookid references BookFK memid references MemberA library may have many books, with each book instance belonging to a single library. However,different copies of the same book can be in different libraries. Each book is associated with aunique author, though an author can write multiple books. Library members can borrow multiplebooks, but each loan record corresponds to a specific book borrowed by a specific member.Library members can borrow books from different libraries.Answer the following queries in SQL points each Find the names of members who have borrowed books from at least different libraries.Display the members name and the number of libraries from which they have borrowedbooks and order the results by the number of libraries in descending order.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
