Aggregation with grouping
Total purchased for each product, per date
THIS IS ILLEGAL
select product_id, purchase_date, sum(total_due)
from purchase
group by purchase_date
Better
select product_id, purchase_date, sum(total_due)
from purchase
group by product_id, purchase_date
|