Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SALES DATA PRODUCT TABLE The data is pretty straight forward: The Product ID Column is common between 2 tables, Since all Product prices are in
SALES DATA PRODUCT TABLE The data is pretty straight forward: The Product ID Column is common between 2 tables, Since all Product prices are in dollars, consider an exchange rate of 66 Rupees for 1 Dollar Answer the following questions. Provide screenshots, where relevant A. Calculate Monthly Commission Payout. Note that commission is only paid on sales done via "Affiliates" channel B. Show Maximum Selling Product Name and its Sales month wise. C. How many high selling days were there in each month. High Selling Day = Total Sales of a Day > \$100. (For e.g., 6 Jan 2011 was a high selling day because the total sales were more than $100 ) SALES DATA PRODUCT TABLE The data is pretty straight forward: The Product ID Column is common between 2 tables, Since all Product prices are in dollars, consider an exchange rate of 66 Rupees for 1 Dollar Answer the following questions. Provide screenshots, where relevant A. Calculate Monthly Commission Payout. Note that commission is only paid on sales done via "Affiliates" channel B. Show Maximum Selling Product Name and its Sales month wise. C. How many high selling days were there in each month. High Selling Day = Total Sales of a Day > \$100. (For e.g., 6 Jan 2011 was a high selling day because the total sales were more than $100 )
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started