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.