Rank Properties by City | Dataford Interview Questions

Write a SQL query using window functions to rank properties by price within each city and return the top 3 per city.

Use the properties table. Exclude properties without a price and make the ordering deterministic by using property_id as the tie-breaker.

Output

One row per selected property, with property_id, city, property_name, price, and price_rank.
Include at most three properties per city, ordered by city, price_rank, and property_id.

properties

Column	Type	Description
property_idPK	INT	Unique property identifier
city	VARCHAR(100)	City where the property is located
property_name	VARCHAR(150)	Listing name or short property description
price	DECIMAL(12,2)	Listing price in US dollars

Your question is Rank Properties by City. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a SQL query using window functions to rank properties by price within each city and return the top 3 per city.

Use the properties table. Exclude properties without a price and make the ordering deterministic by using property_id as the tie-breaker.

One row per selected property, with property_id, city, property_name, price, and price_rank.
Include at most three properties per city, ordered by city, price_rank, and property_id.

properties

Column	Type	Description
property_idPK	INT	Unique property identifier
city	VARCHAR(100)	City where the property is located
property_name	VARCHAR(150)	Listing name or short property description
price	DECIMAL(12,2)	Listing price in US dollars

Your question is Rank Properties by City. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.