========================================================

     Name:Carlos Masson

     Panther-ID: x x x -2059

     Course: COP 4710 

     Assignment#: 2

     Due: Tue, Sep 15, 2020

     I hereby certify that this work is my own and none of
     it is the work of any other person.

                             Signature: Carlos Masson
=========================================================

SELECT Author.AuthorFirst, Author.AuthorLast
FROM Wrote, Author, Book, Inventory, Branch
Where (Wrote.AuthorNum = Author.AuthorNum) 
AND (Book.BookCode = Wrote.BookCode) 
AND (Type = 'MYS') 
AND (Inventory.BookCode = Book.BookCode) 
AND (Branch.BranchNum = Inventory.BranchNum) 
AND (Branch.BranchName = 'Henry Brentwood')
AND (Inventory.OnHand > 0)
GROUP BY Author.AuthorFirst, Author.AuthorLast;