Running Totals & Rolling Windows SQL interview questions

Cumulative and rolling metrics use window frames. These problems cover year-to-date totals, rolling 7-day ratios and Pareto-style cumulative share cut-offs.