company sql set
Airbnb
Airbnb
SQL Set
Hosts, bookings, occupancy, reviews, listings, pricing, guest retention, and stay duration.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Listing Occupancy Rate
Calculate occupancy per listing.
Q02
Top Earning Hosts
Rank hosts by total revenue.
Q03
Frequent Guests
Find guests with repeated monthly bookings.
Q04
Average Review Score per Listing
Average ratings per listing.
Q05
Listings with No Bookings
Find listings never booked.
Q06
Host Activity Consistency
Detect three-month booking streaks.
Q07
Price per Night Analysis
Average nightly price by city.
Q08
Guest Retention
Find guests active in January and February.
Q09
Most Booked City
Find the highest booking city.
Q10
Long Stay Detection
Find stays longer than five days.