CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 28

CIS 336 Final Exam 4 (Devry)
FOR MORE CLASSES VISIT
www.cis336study.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 Final Exam 4 Sets of Answers (Devry)
FOR MORE CLASSES VISIT
www.cis336study.com