Instant Bookings
ASKED IN INTERVIEWAirbnb
Problem Statement
Airbnb users often look for convenience and low additional costs. The marketing team wants to highlight properties that allow Instant Book (no host approval required) and have a cleaning fee of less than $50.
Write an SQL query to retrieve these specific listings.
Rules:
- The property must have instant_book set to TRUE.
- The cleaning_fee must be strictly less than 50.
- Output columns: property_id, property_name, cleaning_fee.
- Sort the results by cleaning_fee in ascending order.
Table Schema:
- Listings: property_id, property_name, property_type, instant_book (BOOLEAN), cleaning_fee (DECIMAL).
Tests your understanding of
Basic SQL, Filtering and Logical Operators
Input Tables
Listings
| property_id(INTEGER) | property_name(VARCHAR) | instant_book(BOOLEAN) | cleaning_fee(DECIMAL) |
|---|---|---|---|
| 1 | Cozy Studio | true | 25 |
| 2 | Beachfront Villa | false | 150 |
| 3 | Modern Loft | true | 49.99 |
| 4 | Shared Room | true | 10 |
| 5 | Mountain Cabin | true | 50 |
| 6 | Downtown Condo | false | 40 |
Expected Output
| property_id(INTEGER) | property_name(VARCHAR) | cleaning_fee(DECIMAL) |
|---|---|---|
| 4 | Shared Room | 10 |
| 1 | Cozy Studio | 25 |
| 3 | Modern Loft | 49.99 |
Tags
EasyASKED IN INTERVIEWBasic SQLFilteringLogical Operators
5 min
92%