1) Show the average Profit value for each combination of Customer Segment and Region

2) For the second half of 2020 (July through December), show each Product Category's sum of Sales a

a percentage of the sum of all Sales during the year (use Ship Date)

3) Show the average Profit value for each combination of Region and Customer Segment

4) For each Order Priority, show the sum of Sales separately for each month of 2019 (use Order Date)

5) Show the 5 largest Order Quantities where Ship Mode = Regular Air and Product Category = Office

Supplies

6) Show the sum of Sales for Product Container = Jumbo Box and Province - Yukon

7) Show the sum of Profit for Product Category Technology and Product Sub-Category - Office

Machines, separately for each month from 7/2018 to 12/2018 (use Order Date)

8) Show all orders (use Order ID) where Profit is greater than $100 and the Order Priority Critical

9) Show the 10 orders (use Order ID) with the highest Quantity during 2019 (use Ship Date)

10) From the Province with the highest sum of Sales, show the five Customer Names with the highest

sum of Sales