80
Then, aggregate
SELECT
product, Sum(price*quantity) AS TotalSales
FROM
Purchase
WHERE
date > “10/1”
GROUPBY
product
