CIS 336 FINAL EXAM 4 DEVRY
To purchase this visit here:
http://www.nerdypupil.com/product/cis-336-final-exam-4-devry/
Contact us at:
nerdypupil@gmail.com
CIS 336 FINAL EXAM 4 DEVRY
CIS 336 Final Exam 4 (Devry)
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 DEVRY
To purchase this visit here:
http://www.nerdypupil.com/product/cis-336-final-exam-4-devry/
Contact us at:
nerdypupil@gmail.com
CIS 336 FINAL EXAM 4 DEVRY
CIS 336 Final Exam 4 (Devry)
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.