Median Price by Superhost

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.

Requirements

1. Calculate the median non-null price separately for superhosts and non-superhosts within each neighbourhood_cleansed value.
2. Exclude neighborhoods that do not contain at least one listing in both host categories.
3. Calculate the signed difference as superhost_median_price - non_superhost_median_price, and return the neighborhood with the largest absolute difference.
4. Return the neighborhood, both medians, the signed difference, and the absolute difference. Round monetary outputs to two decimal places and use deterministic ordering for ties.