CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 31

10. (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 (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.