%========================================================

%     Name: Juan C Ibarra Cuza

%     Panther-ID: x x x - 4175 (last 4 digits)

%     Course: COP 4710

%     Assignment#: 1

%     Due: Tue, Sep 8, 2020

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

%                             Signature: Juan C Ibarra
%     =========================================================

% Get all the books with price higher than $20 
qBooks := project bookCode, title (select (price > 20) (book));

% Get the only the books that are currently avilable at their brach (onHand >0) 
qInventory := project title, branchNum (select (onHand > 0) (inventory njoin qBooks));

% Project the title and branch name of those books
qResult := project title, branchName (qInventory njoin branch);