Calculate the Median House Price in Each City

Read the full interview experience this question came from →

Quick Overview

Calculate median house prices by city in PostgreSQL, handling odd and even group sizes, repeated prices, and exact numeric results.

Calculate the Median House Price in Each City

Company: Airbnb

Role: Data Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Onsite

Overview: Calculate median house prices by city in PostgreSQL, handling odd and even group sizes, repeated prices, and exact numeric results.

Read the full Airbnb Data Engineer interview experience this question came from

Airbnb logo
Airbnb
Sep 4, 2026
mediumData EngineerOnsiteData Manipulation (SQL/Python)
6
0
Practice
Loading...