CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 24

www.uophelp.com
CIS 336 Final Exam 4 Sets of Answers
---------------------------------------------------------------------------------
CIS 336 Final Exam 4
For more course tutorials visit
www.uophelp.com
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.
---------------------------------------------------------------------------------
CIS 336 Group Project