Airbnb's pricing team wants to study expensive neighbourhoods, but only ones with enough listings for the average to mean something.
Find neighbourhoods with at least 10 listings whose average nightly price is above 120.
Expected output
avg_price rounded to 2 decimals; any row orderExample of the shape (made-up values):
| city | neighbourhood | listings | avg_price |
|---|---|---|---|
| Paris | Le Marais | 14 | 151.43 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.