CIS 336 Final Exam 4
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-final-exam-4
1. (TCO 7) For every order, list the order number, order date, part number, part description,
and item class for each part that makes up the order.
2. (TCO 8) Write a query that will display the customer number, last name, and first name for
every customer I whose first name begins with the letter "D".
2. (TCO 8) Write a query that will display the earliest date an order was placed.
3. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders
that were placed during the period of September 3rd thru September 5th of 1998.
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep
commission rate using JOIN ON.