Assume that the LIBRARY database with the schema below has been defined and populated with data.For that database write the SQL queries to accomplish the tasks listed below.

a. How many copies of the The Lost Tribe are owned by the Sharpstown library branch? b. How many copies of the The Lost Tribe are owned by each library branch? c. Retrieve the names of all borrowers who do not have any books checked out. d. For each library branchre,trieve the branch name and the total number of books loaned out from that branch. e. Retrieve the names, addresses, and the number of books checked out by each borrower who checkedout more than five books.

BOOK Book_ id Title Publisher_name BOOK_ AUTHORS Book id Author_name PUBLISHER Name Address Phone BOOK_COPIES Book id Branch id No of copies BOOK LOANS Book id Branch _id Card_no Date out Due_ date LIBRARY BRANCH Branch id Branch name Address BORROWER Card no Name Address Phone