Year-over-Year Revenue Growth

Problem

**[Commonly asked at Amazon, Lyft]**

Given a table of monthly revenue, calculate the **year-over-year growth rate** for
each month — how the revenue changed compared to the same month in the prior year.

Growth rate = `(current_revenue - prior_revenue) / prior_revenue * 100`

Months with no prior-year data should be excluded.
Return `revenue_month`, `current_revenue`, and `yoy_pct` (rounded to 2 dp), ordered by month.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns revenue_month, current_revenue, yoy_pct.

Starter code (SQL)

SELECT *
FROM monthly_rev;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium