Year-over-Year Growth — Solution & ExplanationProblems / Year-over-Year Growth / EditorialApproachYear-over-year growth is a classic analytics calculation that pairs naturally with LAG().

LAG(revenue, 1): Partitioned by quarter, ordered by year, this returns last year's revenue for the same quarter.

Growth formula: (revenue - prev) / prev * 100 gives the percentage change.

NULL handling: The first year has no prior year, so both prev_year_revenue and yoy_growth_pct are NULL.

This pattern works for any periodic comparison: month-over-month, week-over-week, etc.Hints

Partition by quarter so LAG compares the same quarter across years.

Growth formula: (current - previous) / previous * 100.

Multiply by 100.0 (not 100) to avoid integer division in SQL.

Solve Year-over-Year Growth yourself →