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