Airbnb
Analytics Reporting Track · Medium · 25 min
Year-on-year Product Spend Growth
At Airbnb, analysts are preparing a operations review focused on year-on-year product spend growth. Calculate the year-on-year growth rate for each product_i...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Airbnb-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
At Airbnb, analysts are preparing a operations review focused on year-on-year product spend growth. Calculate the year-on-year growth rate for each product_id. Return report_year, product_id, current_year_spend, prior_year_spend, and yoy_growth_pct sorted by report_year and product_id.
This is a Pro question
Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.
Upgrade to Pro — unlock all 254 problemsSQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.