Airbnb's marketing team is writing a "Tokyo on a budget" guide. They only want places that are cheap and well reviewed.
List the Tokyo listings that cost less than 80 a night and have a review score of 4.5 or higher.
Expected output
Return: listing id, name, price per night and review score (name the columns however you like)
listing_id firstExample of the shape (made-up values):
| listing_id | name | price_per_night | review_score |
|---|---|---|---|
| 12 | Tiny room in Asakusa | 45.00 | 4.81 |
Write your query here. Ctrl + Enter submits.