CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 29
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
CIS 336 Final Exam 4 Sets of Answers
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