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...