1. List the number and name of all sales reps.
PROJECT Rep OVER (RepNum, LastName, FirstName)
GIVING Answer

2. List all information from the Part table for part FD21.
SELECT Part WHERE PartNum = 'FD21'
GIVING Answer

3. List the order number, order date, customer number, and customer name for each order.
JOIN Orders, Customer WHERE Orders.CustomerNum=Customer.CustomerNum
GIVING Temp
PROJECT Temp OVER (OrderNum, OrderDate, CustomerNum, CustomerName )
GIVING Answer

4. List the order number, order date, customer number, and customer name for each order placed by any customer represented by the sales rep whose last name is Kaiser.
JOIN Orders, Customer WHERE Orders.CustomerNum=Customer.CustomerNum
GIVING Temp1
JOIN Temp1, Rep WHERE Temp1.RepNum=Rep.RepNum
GIVING Temp2
SELECT Temp2 WHERE Rep.LastName= ‘Kaiser’
GIVING Temp3
PROJECT Temp3 OVER (OrderNum, OrderDate, CustomerNum, CustomerName)
GIVING Answer

5. List the number and date of all orders that were placed on 10/20/2013 or that were placed by a customer whose rep number is 20.
SELECT Orders WHERE OrderDate= ‘10/20/2013’
GIVING Temp1
PROJECT Temp1 OVER (OrderNum, OrderDate)
GIVING Temp2
JOIN Orders, Customer WHERE Orders.CustomerNum=Customer.CustomerNum
GIVING Temp3
SELECT Temp3 WHERE RepNum= ‘20’
GIVING Temp4
PROJECT Temp4 OVER (OrderNum, OrderDate)
GIVING Temp5
UNION Temp2 WITH Temp5
GIVING Answer

6. List the number and date of all orders that were placed on 10/20/2013 by a customer whose rep number is 20.
SELECT Orders WHERE OrderDate= ‘10/20/2010’
GIVING Temp1
PROJECT Temp1 OVER (OrderNum, OrderDate )
GIVING Temp2
JOIN Orders, Customer WHERE Orders.CustomerNum=Customer.CustomerNum
GIVING Temp3
SELECT Temp3 WHERE RepNum=20
GIVING Temp4
PROJECT Temp4 OVER (OrderNum, OrderDate )
GIVING Temp5
INTERSECT Temp2 WITH Temp5
GIVING Answer

7. List