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?

A

NULL, 150.0, 80.0

B

NULL, 50.0, -20.0

C

NULL, 50.0, -25.0

D

0.0, 50.0, -20.0