Question: Library ( Library _ id , lib _ name, city, address ) Book ( Book _ id , book _ title, book _ genre, publication

Library (Library_id, lib_name, city, address)Book (Book_id, book_title, book_genre, publication_year, auth_id, lib_id)FK (lib_id) references LibraryFK (auth_id) references AuthorAuthor (Auth_id, auth_name, auth_birthyear, country)Member (Mem_id, mem_name, mem_joindate, city)Loan (Loan_id, book_id, mem_id, loan_date, return_date)FK (book_id) references BookFK (mem_id) 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.(10 points each)1. Find the names of members who have borrowed books from at least 3 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!