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.

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

d. Write a query to list the names (last name and first name) and extension of employees who report to individuals who have the same job title.

e. Write a query to display the name (last name and first name) of the employee and the amount of business he has generated (i.e. how many dollars worth of product has an employee sold). Order the results in descending value of dollars worth of products sold.

Use model:

Offices Payments checkNumber paymentDate addres sLine 1 customerNumber OfficeLo cation Customers ? customerNumber customerName contactastName contactFirstName Employees reportsTo | Productines salesRepEmployeeNumber textDescription custome rLoc ation Products Orders OrderDetails OrderDate requiredDate t productCode shipped Date quant ityOrdered priceEach orderLineNumber productDescription custome rNumber