SELECT
    product, 
    SUM(quantity) qty
FROM
    inventory
GROUP BY
    product;