Question: Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of 5.00 Write the function

Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of 5.00 Write the function to calculate the output shown in output table i.e. Q1 Number of Shirt white sold in Feb in USA P Flag question Q2 Total Sales Revenue of Shirt white sold Q3 Average sales revenue of UK Q4 Sales by Nancy Freehafer Q5 Total sales in USA in Feb Table 1 Month Product Country USA Jan Shirt white IT Jan Shirt blue Sales Revenue Sales Representative $546.00 Mariya Sergienko $519.00 Mariya Sergienko UK Feb Shirt white USA $492.00 Andrew Cencini Feb Shirt blue USA $559.00 Nancy Freehafer Feb Pant white UK $591.00 Jan Kotas Feb Shirt white USA $535.00 Jan Kotas Mar Shirt yellow USA $468.00 Anne Larsen Apr Shirt blue USA $568.00 Anne Larsen Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of 5.00 Write the function to calculate the output shown in output table i.e. Q1 Number of Shirt white sold in Feb in USA P Flag question Q2 Total Sales Revenue of Shirt white sold Q3 Average sales revenue of UK Q4 Sales by Nancy Freehafer Q5 Total sales in USA in Feb Table 1 Month Product Country USA Jan Shirt white IT Jan Shirt blue Sales Revenue Sales Representative $546.00 Mariya Sergienko $519.00 Mariya Sergienko UK Feb Shirt white USA $492.00 Andrew Cencini Feb Shirt blue USA $559.00 Nancy Freehafer Feb Pant white UK $591.00 Jan Kotas Feb Shirt white USA $535.00 Jan Kotas Mar Shirt yellow USA $468.00 Anne Larsen Apr Shirt blue USA $568.00 Anne Larsen
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
