Challenge
Write a query that calculates the cumulative sum of Closed Won Opportunities per Account.
Return the AccountId and use the alias totalAmount
to represent the total amount.
Return the results sorted in any order.
The result format is in the following example:
AccountId | totalAmount |
---|---|
0018b00002NwouzAAB | 50335.12 |
0010b00002GUxv2BBO | 900001.33 |
0018c000025HMOPAA4 | 890003.99 |