Airbnb
Interview Core Track · Easy · 15 min
Waitlist Fill Rate
Marketplace ops wants to see how efficiently waitlists are being cleared. Return each city, the total number of waitlist requests, and the percentage of fulf...
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 improve speed, edge-case handling, and accuracy under timed conditions.
Company context
Company labels are directional practice context, not official interview guidance.
Marketplace ops wants to see how efficiently waitlists are being cleared. Return each city, the total number of waitlist requests, and the percentage of fulfilled requests rounded to two decimals. Sort by city.
listings
| listing_id | city |
|---|---|
| 1 | Austin |
| 2 | Austin |
| 3 | Denver |
| 4 | Miami |
waitlist_requests
| request_id | listing_id | fulfilled |
|---|---|---|
| 101 | 1 | true |
| 102 | 1 | false |
| 103 | 2 | true |
| 104 | 3 | false |
| 105 | 3 | false |
| 106 | 4 | true |
SQL 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.