Using this same dataset that you used previously, please prepare a report that answers the following questions.
Again, the format should look something like this:
10. What was the invoice number of the largest invoice by revenue that sales person Wendel wrote during the analysis period?
11. Over the entire analysis period, what is the rank of sales persons according to the dollar value of discounts given, from most discounts to least discounts?
12. Which month had the highest revenue?
13. Only considering postal codes 3013, 3017 and 3031, which item had the highest total profit during the month of February?
14. What is the rank of months from highest to lowest based on profit over the entire analysis period?
15. During which 3 months did manager John Jones have the highest cumulative profit ignoring all sales to postal codes 3019 and 3028 and ignoring all sales of items 4, 5, 6, 17 and 18?
16. What quantity of item 3 was sold by sales persons Benny and Kelly together during the month of June?