SQL Server Transact Basic to Expert - Using Average function

This blog shows how to do an average of group of values using the Average function in SQL Server

Example:

SELECT ProductID, AVG(Rating) AverageRating
FROM DBO.ProductReview
GROUP BY ProductID

AVG() - this is the function used to do the average.