01069-prooduct-sales-analysis-ii.sql

-- simple aggregate

select product_id, sum(quantity) as total_quantity
from Sales
group by 1

-- amazon- 1