Cumulative Sum Window

Hard
window-functions Airbnb Stripe Two Sigma

Write a query to calculate a running total of daily sales. Return sale_date, daily_amount, and running_total, ordered by sale_date.

Expected Output: Each day's sales with the cumulative total up to that day.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...