Aggregation with grouping
Total purchased (ever)
select sum(total_due)
from purchase
| ... |
purchase_date |
... |
total_due |
... |
| ... |
04/19/2015 |
... |
10.00 |
... |
| ... |
04/19/2015 |
... |
25.00 |
... |
| ... |
09/21/2017 |
... |
50.00 |
... |
| ... |
09/21/2017 |
... |
18.00 |
... |
Query output: 103.00
|