Month-over-Month Growth — Solution & ExplanationProblems / Month-over-Month Growth / EditorialApproach

LAG window function: LAG(revenue) OVER (ORDER BY month_date) accesses the previous month's revenue without a self-join.

Growth formula: (current - previous) / previous * 100 gives the percentage change.

Filter NULLs: The first month has no previous value, so filter it out.

Key ConceptMonth-over-month growth is one of the most common business metrics. The LAG() window function makes this computation clean and efficient compared to self-join alternatives.Hints

Use LAG(revenue) OVER (ORDER BY month_date) to get the previous month's value.

Growth percentage = (current - previous) / previous * 100.

Exclude the first row where LAG returns NULL.

Solve Month-over-Month Growth yourself →