Rolling 7-Day Notional With Missing Days

SQL practice question · Hard · Date & Time · Goldman Sachs

For each desk build a row for EVERY calendar date from the desk's first to its last trade_date (days without trades have daily_notional 0). rolling_7d_avg = average daily_notional over the current day and the 6 previous calendar days, counting zero days; near the desk's first date use only the days that exist (from the first date). Return desk, trade_date, daily_notional (ROUND 2) and rolling_7d_avg (ROUND 2). Order by desk, trade_date.

Table: desk_trades

Solve it in the live editor on this page — run on sample data, then submit against hidden tests.

‹ Normalise Messy Expense Claims · Structuring: Near-Threshold Deposits in 7 Days ›