Question: IDS i dont understand how to do the last 5 steps. can you explain how to do them. Im super confused. thank you. I need

1) Show the average Sales value for each combination of Customer Segment and Order Priority 2) Show the average Profit value for each combination of Region and Customer Segment 3) For each Province, show the sum of Sales separately for each month from 4/2020 to 6/2020 (use Order Date) 4) For the entire year 2020, show each Ship Mode's sum of Sales as a percentage of the sum of all Sales during the year (use Ship Date) 5) Show the 10 largest Order Quantities where Customer Segment = Corporate and Product Category = Office Supplies 6) Show the sum of Sales for Product Container = Jumbo Box and Region = Quebec 7) Show the sum of Profit for Product Category = Technology and Product Sub-Category = Computer Peripherals, separately for each month from 1/2019 to 6/2019 (use Order Date) 8) Show the 10 orders (use Order ID) with the highest Unit Price during 2019 (use Ship Date) 9) Show all orders (use Order ID) where Profit is negative and the Order Priority = Low 10) From the Province with the highest sum of Sales, show the five Customer Names with the highest sum of Sales
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
