CIS336 Final Exam 4

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.

Photos

CIS336 Final Exam 4
$10.00 Tax included. Shipping not included.

User reviews

No reviews. Be the first to write one!

Delivery

All purchases are sent via email. Check your inbox and spam folder for an email from DevryGenius.com.

Promotions

Subscribe to our newsletter to receive special discounts and offers.

Contact us

DevryGenius.com
New York, NY 10011
support@devrygenius.com,

Newsletter

Sign up and never miss another deal.