Another Example

SELECT product, Sum(price * quantity) AS SumSales

Max(quantity) AS MaxQuantity

FROM Purchase

GROUP BY product

For every product, what is the total sales and max quantity sold?

Previous slide

Next slide

Back to first slide

View graphic version