Second-Priciest Listing per Neighborhood

Problem

A property portal stores listings with an asking price and the neighborhood they sit in. For each neighborhood, find the listings whose asking price is the second-highest distinct price in that neighborhood. If several listings share that second-highest price, return all of them. Skip any neighborhood that has fewer than two distinct price levels. Return listing_id and neighborhood, ordered by listing_id.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns listing_id, neighborhood.

Starter code (SQL)

SELECT *
FROM listings;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium