Your question is Median Price by Superhost. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Turing's marketplace analytics team wants to identify neighborhoods where Turing listings managed by superhosts have the largest pricing difference compared with non-superhost listings. Write a PostgreSQL query using the listings table.
price separately for superhosts and non-superhosts within each neighbourhood_cleansed value.superhost_median_price - non_superhost_median_price, and return the neighborhood with the largest absolute difference.| Column | Type | Description |
|---|---|---|
| listing_idPK | INTEGER | Unique listing identifier |
| host_is_superhost | BOOLEAN | Whether the listing host is a superhost |
| neighbourhood_cleansed | VARCHAR(100) | Standardized neighborhood name |
| price | NUMERIC(10,2) | Nightly listing price |