|< < 35 > >|

Aggregation with grouping

Total purchased per date


select purchase_date, sum(total_due)
from purchase
group by purchase_date

Output:

purchase_date sum(total_due)

04/19/2015 35.00

9/21/2017 68.00

|< < 35 > >|