This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Market Analyst at Zillow. The product team wants to display a price rank badge on each sale listing within its city. For example, the most expensive listing in Denver would show "Rank 1 of 3 in Denver." Your job is to compute a dense price rank for every sale listing, grouped by city.
You are a Market Analyst at Zillow. The product team wants to display a price rank badge on each sale listing within its city. For example, the most expensive listing in Denver would show "Rank 1 of 3 in Denver." Your job is to compute a dense price rank for every sale listing, grouped by city.