1. Management has asked you to give Customer information (output all fields from customer table), for any customer who ordered one of our 5 cheapest parts. Take a look in the part table, and you'll see the price of each part. Your final output should not repeat customer information, so make sure it is a unique list of customers. Order your final results by customer name in ascending order.

2. Management would also like to know the part names for our top 5 best selling parts, in terms of quantity sold. When looking at the data, you will realize there are actually 6 parts that qualify as being in the top 5 in terms of quantity sold. Remember data in a relational (transaction) database changes rapidly, so your query needs to be dynamic, so that it always returns all names of parts that qualify as being in the top 5 in terms of quantity sold.

3. Form a query to show customer information (output all fields from the customer table), who placed an order with us where the order total (revenue) was larger than the average revenue order placed. So, if customer 1 places an order with us and the total revenue generated was 1,630 and the average revenue for all orders was 1,500 then customer 1 makes the list. Obviously if customer 1 places another order with us and the total revenue for the order was 1,200 then that order does not qualify them to make the list. Please be sure to output a unique list of customer information and your final output can be ordered anyway you'd like.

It would be awesome to figure out how to show each customer who qualifies as placing an order with revenue > the average, and also show how many orders that customer placed which met that criteria. This is not required to receive full credit, but see if you can figure this out.

4. Management would like to figure out which part generated the lowest revenue. Consider just parts which were purchased by customers, since obviously revenue for any part not sold would be $0. Recall revenue is calculated by multiplying price and quantity, so write a query to output all attributes from the part table, where the revenue generated from the part, was the lowest of any part that was sold.

There will be only one row output from this query, but the query should be written in a way, that if part 153 and part 320 both generated $390 in revenue (which was the lowest), then all information for both part 153 and part 320 would appear in the query results.