Exercises

List products sorted by orders generated

List products sorted by orders generated, and include a description of the product

What is the most popular product (include its description), and how many orders where generated for it?

List products in order by revenue generated

List products in order by revenue and include a description of the product

What product (including description) generated the most revenue and what was that revenue?

What is the total number of orders and average revenue of an order for each customer ranked by average revenue of an order?

What is the name of the customer who buys the most product?

What is the name of the customer who buys the lest product?

Rank sales people by revenue generated.