Month Over Month
monthly:
| month | revenue |
|---|---|
| 2026-01 | 300 |
| 2026-02 | 450 |
| 2026-03 | 360 |
SELECT month, revenue,
round(100.0 * (revenue - lag(revenue) OVER (ORDER BY month))
/ lag(revenue) OVER (ORDER BY month), 1) AS pct_change
FROM monthly
ORDER BY month;
What are the three pct_change values?
Sign in to answer questions and track your progress
Sign In