Problem 2 of 8 · LAG, LEAD & Value FunctionsNext: Time to next event per user

00:00

Practice / SQL / LAG, LEAD & Value Functions

WorkingGuided

EasyAbout 5 minLAG, LEAD & Value FunctionsLesson: LAG, LEAD & Value Functions (P17) →

Month-over-month revenue change

For each month, return the prior month's revenue and the absolute change (current − prior). The first month gets NULL for both.

Sort by month ascending.

Returnmonthrevenueprev_month_revmom_change

Columns

monthly_revenue2 columns

columntype

monthDATE

revenueBIGINT

The table

17 rows · 2 columns

monthly_revenuefirst 5 of 17 rows

monthrevenue

2025-01-011000

2025-02-011100

2025-03-01950

2025-04-011200

2025-05-011400

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows