Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given a table of purchases by date, calculate the month - over - month percentage change in revenue. The output should include the year -
Given a table of purchases by date, calculate the month over month percentage change in revenue. The output should include the year month date YYYY MM and percentage change, rounded to the nd decimal point, and sorted from the beginning of the year to the end of the year. The percentage change column will be populated from the nd month forward and can be calculated as this month's revenue last month's revenue last month's revenue
Tables Schema as Below:
purchases
columnName dataType
id INT
createdat DATE
value DECIMAL
purchaseid INT
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