Top Listings by Zip Code

MediumSQL · PostgreSQL

Write a query to find the top three most expensive listings in each zip code using window functions.

Use the listings table. Exclude rows with a missing ZIP code or listing price.

Output

One row per selected listing, with listing_id, zip_code, list_price, and listing_rank.
Return at most three listings per ZIP code, ordered by zip_code, then listing_rank.
Rank higher-priced listings first; break equal-price ties by ascending listing_id.

listings

Column	Type	Description
listing_idPK	INT	Unique identifier for the listing
zip_code	VARCHAR(10)	ZIP code where the listing is located
list_price	NUMERIC(12,2)	Current asking price of the listing

Tableslistings

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.