More Grouping Functions

SELECT Category, Avg(Price), Min(Quantity), Sum(Price*Quantity)

FROM Product

WHERE SupplierID in (1, 2) or SupplierID is null

GROUP BY Category

ORDER BY Avg(Price)

Previous slide

Next slide

Back to first slide

View graphic version