Calculate the Monthly Share of High-Frequency Customers

Quick Overview

A PostgreSQL interview problem about measuring the monthly percentage of customers who place more than 30 deliveries. It tests calendar-month aggregation, distinct-customer denominators, threshold logic, and precise percentage calculation.

Calculate the Monthly Share of High-Frequency Customers

Company: DoorDash

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Technical Screen

Overview: A PostgreSQL interview problem about measuring the monthly percentage of customers who place more than 30 deliveries. It tests calendar-month aggregation, distinct-customer denominators, threshold logic, and precise percentage calculation.

|Home/Data Manipulation (SQL/Python)/DoorDash
DoorDash logo
DoorDash
Jul 27, 2026
easyData ScientistTechnical ScreenData Manipulation (SQL/Python)
23
0
Loading...
Loading comments...