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.
