Problem 4 of 8 · LAG, LEAD & Value FunctionsNext: Quarter-over-quarter from monthly data

00:00

Practice / SQL / LAG, LEAD & Value Functions

WorkingGuided

MediumAbout 8 minLAG, LEAD & Value FunctionsLesson: LAG, LEAD & Value Functions (P17) →

Month-over-month growth per category

For each category, return MoM growth percent — current month's revenue vs. that category's previous month. Round to 2 decimals. First month per category gets NULL.

Sort by category ascending then month ascending.

Returncategorymonthrevenuemom_pct

Columns

cat_monthly3 columns

columntype

categoryVARCHAR

monthDATE

revenueBIGINT

The table

18 rows · 3 columns

cat_monthlyfirst 5 of 18 rows

categorymonthrevenue

electronics2025-12-011200

electronics2026-01-011100

electronics2026-02-011300

electronics2026-03-011500

electronics2026-04-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