Running Revenue by Salesperson

Medium
window-functions Salesforce Stripe LinkedIn

For each sale, calculate the running total of amount per salesperson, ordered by sale_date. Return salesperson, sale_date, amount, and running_total, ordered by salesperson then sale_date.

Expected Output: Running total resets per salesperson.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...