Refer to : http://richardtwatson.com/dm6e/images/general/ClassicModels.png

Can anyone help me out with these sql query?

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.