Company Focus

Airbnb Interview Problems (45)

Problems reported from Airbnb data science interviews

Status Title Difficulty
Recursion vs Iteration Pro Medium
ROW_NUMBER for Pagination Pro Medium
Self Join to Find Employee Pairs in Same Department Pro Medium
Statistical Power Pro Medium
Top N Per Group with ROW_NUMBER Pro Medium
Unlock all 45+ problems
Unmatched Records: Orders Without Customers Pro Medium
Bootstrapping Method Pro Hard
Cohort Retention Rate With CTEs Pro Hard
Cumulative Sum Window Pro Hard
Hierarchical Self Join for Org Chart Pro Hard
Unlock all 45+ problems
Latest Order Per Customer Using Join and Subquery Pro Hard
Log Loss as Evaluation Metric Pro Hard
Month-Over-Month Revenue Change Pro Hard
Multi-Step Funnel Analysis With CTEs Pro Hard
North Star Metric Selection Pro Hard
Unlock all 45+ problems
NTILE for Quartile Bucketing Pro Hard
Permutation Test Mechanics Pro Hard
REST API Design Principles Pro Hard
Running Total of Order Amounts Per Customer Pro Hard
Windowed Aggregation Pro Hard
Unlock all 45+ problems
Show 25 50 100 per page