GROUP BY 使用 SUM 函式

SELECT product, SUM(quantity) AS "Total quantity"
FROM order_details
GROUP BY product;