CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 29
9.( TCO 7) Write a query that will list the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12.
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
9.( TCO 7) Write a query that will list the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12.
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