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.

Loading…