Month-Over-Month Revenue Change
Hard
window-functions
Netflix
Spotify
Airbnb
Calculate the month-over-month revenue change for a store. Return month, revenue, prev_month_revenue, and change, ordered by month. prev_month_revenue and change should be NULL for the first month.
Expected Output: Revenue with previous month and absolute change.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...