Quick Overview

A PostgreSQL interview problem about calculating month-over-month restaurant sales growth. It tests monthly aggregation, window functions, missing prior periods, division-by-zero handling, and deterministic result ordering.

Calculate Monthly Restaurant Sales Growth

Company: DoorDash

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Technical Screen

Overview: A PostgreSQL interview problem about calculating month-over-month restaurant sales growth. It tests monthly aggregation, window functions, missing prior periods, division-by-zero handling, and deterministic result ordering.

Loading…