Airbnb SQL interview questions
Two-sided marketplace metrics — hosts, guests, bookings and rankings. Practice reconstructed Airbnb-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.
sqlpythonpandaseasy2medium4hard2
typical interview loop
- 1.Recruiter screen
- 2.Technical screen: 2–3 SQL questions in a shared editor (~45 min)
- 3.Onsite: SQL / Python coding, product-sense metrics case, behavioral
- › Ranking within groups (ROW_NUMBER / DENSE_RANK) is a staple.
- › Think about both sides of the marketplace.
most-tested topics
groupby
2
agg
2
JOIN
2
GROUP BY
2
Window functions
2
WHERE
1
Based on 8 reconstructed Airbnb-style questions.
practice path
1 free · 7 Protype
level
- 1Filter active listings by citysqleasy
- 2Nightly price bucketspythoneasy
- 3Host listing summarypandasmedium
- 4Occupancy revenue per hostpandasmedium
- 5Revenue per citysqlmedium
- 6Top-rated listing per citysqlmedium
- 7Highest rated listing per citysqlhard
- 8Maximum booking overlappythonhard
Unlock all 8 Airbnb questions with Pro.
upgrade