Problem 7 of 8 · LAG, LEAD & Value FunctionsNext: Flag orders that sat on hold too long

00:00

Practice / SQL / LAG, LEAD & Value Functions

WorkingGuided

HardAbout 12 minLAG, LEAD & Value FunctionsLesson: LAG, LEAD & Value Functions (P17) →

Stacked t-1, t-3, t-12 via date arithmetic

For each month, attach revenues from EXACTLY 1, 3, and 12 calendar months prior — using date arithmetic, NOT LAG with row offsets.

Sort by month ascending. Missing prior periods appear as NULL.

Returnmonthrevenueprev_1mprev_3mprev_12m

Columns

monthly_revenue2 columns

columntype

monthDATE

revenueBIGINT

The table

16 rows · 2 columns

monthly_revenuefirst 5 of 16 rows

monthrevenue

2025-01-011000

2025-02-011100

2025-04-011200

2025-05-011400

2025-06-011300

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