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

     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 Rep.LastName, Part.Description
FROM Rep, Part, Customer
WHERE Customer.RepNum = Rep.RepNum 
AND Customer.CustomerNum IN 
(SELECT Orders.CustomerNum
FROM Orders, OrderLine, Part
WHERE Orders.OrderNum = OrderLine.OrderNum 
AND OrderLine.PartNum = Part.PartNum) 
AND NOT EXISTS
(SELECT * from Customer
WHERE CustomerNum IN 
(SELECT CustomerNum 
FROM Orders
WHERE OrderNum IN 
(SELECT OrderNum
FROM OrderLine 
WHERE PartNum IN 
(SELECT PartNum
FROM Part))))