CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 28

8. (TCO 8) Write a query that will display the customer
number, first name, and last name for every customer with a
balance greater than $50. Display the first and last name as a
single column and provide an alias for the column.
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".