Quick Overview

Solve a PostgreSQL rolling-revenue problem that needs a complete daily series per seller, including no-order dates. It assesses UTC date handling, gap filling, status filters, window semantics, numeric precision, and partial seven-day histories.

Compute a Rolling Seven-Day Revenue Sum with Missing Dates

Company: Amazon

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Overview: Solve a PostgreSQL rolling-revenue problem that needs a complete daily series per seller, including no-order dates. It assesses UTC date handling, gap filling, status filters, window semantics, numeric precision, and partial seven-day histories.

Loading…