Do Exercises $8\mathrm{.}18(1.3.5.7.),$ in addition to relational expressions$$also write the queries in SQL statements.

Exercise $8\mathrm{.}18$:

Consider the LIBRARY relational database schema shown in Figure $8\mathrm{.}14,$ which is used to keep track of books, borrowers, and book loans. Referential integrity constraints are shown as directed arcs in Figure $8\mathrm{.}14,$ as in the notation of Figure $5\mathrm{.}7.$ Write down relational expressions for the following queries:

a$.$ How many copies of the book titled The Lost Tribe are owned by the library branch whose name is $$Sharpstown$?$

c$.$ Retrieve the names of all borrowers who do not have any books checked out.

e$.$ For each library branch, retrieve the branch name and the total number of books loaned out from that branch.

g$.$ For each book authored $($or coauthored$)$ by Stephen King, retrieve the title and the number of copies owned by the library branch whose name is Central.

BOOK