For this homework assignment you will need to utilize the Classic Cars information located here - http://richardtwatson.com/dm6e/Reader/ClassicModels.html

Write the SQL to answer the following queries.

Single entity

a. Report those payments greater than $100,000.

b. List the products in each product line.

c. How many products in each product line?

d. What is the minimum payment received?

e. List all payments greater than twice the average payment.

One to many relationship

f. How many orders have been placed by Herkku Gifts?

g. Who are the employees in Boston?

h. Report those payments greater than $100,000. Sort the report so the

customer who made the highest payment appears first.

i. List the value of 'On Hold' orders.

j. Report the number of orders 'On Hold' for each customer.

Many to many relationship

k. List those orders containing items sold at less than the MSRP.

l. Reports those products that have been sold with a markup of 100% or

more (i.e., the priceEach is at least twice the buyPrice)

m. List the products ordered on a Monday.

n. What is the quantity on hand for products listed on 'On Hold' orders?