Median-Priced Listing in Each Neighborhood

Problem

Table: `Listing`

```text
+--------------+---------+
| Column | Type |
+--------------+---------+
| listing_ref | int |
| neighborhood | varchar |
| price | int |
+--------------+---------+
listing_ref is the primary key.
```

For each neighborhood, return the row (or rows) holding the **median price**. When a neighborhood has an odd number of listings there is one median row; when it has an even number there are two. Sort prices ascending to find the middle, and break ties on equal prices by `listing_ref` ascending. Return the columns `listing_ref`, `neighborhood`, `price` in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns listing_ref, neighborhood, price.

Starter code (SQL)

SELECT *
FROM Listing;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard