Aggregation with grouping
Total purchased per date
select purchase_date, sum(total_due)
from purchase
group by purchase_date
| ... |
purchase_date |
... |
total_due |
... |
| ... |
04/19/2015 |
... |
10.00 |
... |
| ... |
04/19/2015 |
... |
25.00 |
... |
| ... |
09/21/2017 |
... |
50.00 |
... |
| ... |
09/21/2017 |
... |
18.00 |
... |
|