3 SQL practice questions in our Airbnb collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy · 1 Medium · 1 Hard
Independent practice resource. Not affiliated with or endorsed by Airbnb.
These topics come from the questions in this set. Pick one to open the matching problems.
Analyze guest review scores by gender for completed bookings in 2026. For each gender group, calculate: average rating, total number of reviews, and percentage of five-star reviews. Handle null gender values by treating them as 'Unknown'. Return columns: gender, average_rating, review_count, pct_five_star. Order by average_rating descending.
Calculate the click-through rate (CTR) for Airbnb listings viewed in March 2026. For each listing, return: listing_id, room_type, neighborhood, view_count (distinct views), booking_count (bookings within 30 days), and ctr_percent (bookings / views * 100). Only include listings with at least 10 views. Order by CTR descending.
Analyze host growth and quality from 2024 to 2025. For hosts who had active listings in both years, calculate: listing_count_2024, listing_count_2025, growth_rate (percentage increase), average_rating from 2025 bookings, and quality_rank (ranked by average rating). Only include hosts with growth > 0 (more listings in 2025 than 2024). Return: host_id, is_superhost, listing_count_2024, listing_count_2025, growth_rate, avg_rating, quality_rank. Order by growth_rate descending.
3 Airbnb problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
booking_id (BIGINT) · guest_id (BIGINT) · listing_id (BIGINT) · checkin_date (DATE) · booking_status (VARCHAR)
guest_id (BIGINT) · gender (VARCHAR) · signup_date (DATE)
review_id (BIGINT) · booking_id (BIGINT) · rating (INTEGER) · review_date (DATE)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Airbnb SQL free188 SQL practice questions. 23 companies. Free access to every problem.