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

%     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 the all the parts that belong to the SG or HW class 
qParts := project partNum (select class = 'SG' or class = 'HW' (part));

% Get the all order lines that contains those parts
qOrderLine := qParts njoin (project orderNum, partNum (orderLine));

% Get the order number belonging to the order line using njoin with the orders table.
qOrders := qOrderLine njoin orders;

% Project the cutomerName and order date for those orders using njoin with the customer table.
answer1 := project customerName, orderDate( qOrders njoin customer);

% If I only project  customerName and orderDate on the query the last row won't show becouse a set cannot have to identical elements 
answer2 := project orderNum, customerName, orderDate( qOrders njoin customer);