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

Loading…