Q$6.$ SQL

$($Ci$)$

$5**2=10$Marks

Book $($bookid$,$title,publishername$)$

Book$\_$authors $($bookid$,$authorname$)$

Publisher $($name$,$address, phone$)$

Book$\_$copies $($bookid$,$branched,no$\_$of$\_$copies$)$

Book$\_$loans $($bookid$,$branched,cardno,dateout,duedate$)$

Library$\_$branch $($branched$,$branchname,address$)$

Borrower $($cardno$,$name,address, phone$)$

Using SQL statements to perform the following tasks:

$6\mathrm{.}1.$ How many copies of the book titled The Lost Tribe are owned by the library branch whose name is "Sharpstown"? $($use appropriate JOIN$)$