Airbnb
Interview Core Track · Medium · 25 min
10074 Find The Average Age Of Guests Reviewed By Each Host
SELECT from_user, AVG(age) as average_age FROM airbnb_reviews r JOIN airbnb_guests g ON r.to_user = g.guest_id WHERE from_type = 'host' GROUP BY from_user
Company labels are directional practice context, not official interview guidance.
Objective
Practice joins 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.
SELECT from_user, AVG(age) as average_age FROM airbnb_reviews r JOIN airbnb_guests g ON r.to_user = g.guest_id WHERE from_type = 'host' GROUP BY from_user
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.