Quick Overview

A PostgreSQL interview problem about ranking monthly customers while excluding users who meet a high-frequency threshold. Candidates must build the eligible population correctly, aggregate orders, apply deterministic ranking, and handle ties explicitly.

Find Monthly Top Customers Excluding High-Frequency Users

Company: DoorDash

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Technical Screen

Overview: A PostgreSQL interview problem about ranking monthly customers while excluding users who meet a high-frequency threshold. Candidates must build the eligible population correctly, aggregate orders, apply deterministic ranking, and handle ties explicitly.

Loading…