82
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?
