Based on the ClassicModels database and the following data model for the database viewable at http://www.richardtwatson.com/dm6e/images/general/ ClassicModels.png a. Write a query to list the customer names, the number of orders whose status is In Process and the number of products in those orders.

b. Write a query to display the customer name for all customers that are not from the USA. Order the results by country and customer name.

c. Write a query to list the different offices (their address), the number of employees at the office and the number of orders that employees at that office were sales representatives for.

d. Write a query to display the name (last name and first name) of the employee and the amount of business they have generated (i.e. how many dollars worth of product has an employee sold) as a percentage of the total sales volume. Make sure you have a rounded result to decimal places with a % sign at the end. Order the results in descending value of dollars worth of products sold.

e. Write a query to list the customer name, the number of orders placed by the customer and the total value of the orders placed by the customer if they have placed more than 5 orders. Order the results by the total value of orders in descending order.