Rep ( RepNum, LastName, FirstName, Street, City, State, Zip, Commission, Rate )
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum )
Orders ( OrderNum, OrderDate, CustomerNum )
OrderLine (OrderNum, PartNum, NumOrdered, QuotedPrice )
Part (PartNum, Description, OnHand, Class, Warehouse, Price )
Based on the code above, list the number and name of all customers.
Answer
SELECT Customer OVER ( CustomerNum, CustomerName ) GIVING Answer
PROJECT Customer OVER ( CustomerNum, CustomerName ) GIVING Answer
JOIN Customer OVER ( CustomerNum, CustomerName ) GIVING Answer
INTERSECT Customer OVER ( CustomerNum, CustomerName ) GIVING Answer