Then, aggregate

SELECT product, Sum(price * quantity) AS TotalSales

FROM Purchase

GROUP BY product

Previous slide

Next slide

Back to first slide

View graphic version