mahir_data
hardShopee · windowPro

Running total of daily sales

Shopee's finance team wants a cumulative view of sales during a campaign.

From the daily_sales table, return each sale_date, its amount, and the running total of amount ordered by date as running_total. Order the output by sale_date.

Schema

daily_sales
sale_dateDATE
amountNUMERIC(10,2)

Pro

The example input, expected output, and walkthrough for this question unlock with a Pro plan.

Pro

This is a Pro question

Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.

See Pro plans