Can you verfiy I am doing these queries in SQL correctly? If not can you give some feedback on what I am not doing correctly? Thank you!

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

SELECT NumberOfCopies

FROM BOOK, BOOK_COPIES, LIBRARY_BRANCH

WHERE BOOK.BookID = BOOK_COPIES.BookID

AND LIBRARY_BRANCH.BranchName = Sharpstown

AND BOOK.Title = The Lost Tribe ;

2) How many copies of the book titled The Lost Tribe are owned by each library branch?

SELECT NumberOfCopies

FROM BOOK, BOOK_COPIES, LIBRARY_BRANCH

WHERE BOOK.BookID = BOOK_COPIES.BookID

AND BOOK.Title = The Lost Tribe ;

3) Retrieve the names of all borrowers who do not have any books checked out.

SELECT Name

FROM BORROWER

WHERE CardNumber NOT IN (SELECT CardNumber

FROM BOOK_LOANS);

Book BooklD Title PublisherName Book_Authors BookID AuthorsName Publisher Name Address Phone Book_Copies BookID BranchlD NumberOfCopies Book Loans BookID BranchID CardNumber DateOut DueDate Library_Branch BranchID BranchName Address Borrower CardNumber Name Address Phone