http://richardtwatson.com/dm6e/Reader/ClassicModels.html

Above is a link to the data model that helps with writing the correct SQL. I REALLY need help.

1. Who is at the top of the organization (i.e., reports to no one)?

2. Who reports to William Patterson?

3. List all the products purchased by Herkku Gifts.

4. Compute the commission for each sales representative, assuming the commission is 5% of the cost of an order. Sort by employee last name and first name.

5. What is the difference in days between the most recent and oldest order date in the Orders file?

6. Compute the average time between order date and ship date for each customer ordered by the largest difference.

7. What is the value of orders shipped in August 2004?

8. List the employees who report to those employees who report to Diane Murphy. Use the CONCAT function to combine the employee's first name and last name into a single field for reporting.

9. Report the names of all customers and if they have placed any orders, list the order numbers associated with them. If a customer has not placed any orders, be sure to include the name of that customer in your report.