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.
SQL Server Transact Basic to Expert - Using Average function
SQL Server Transact Basic to Expert - Using Average function
Join the conversation! Your thoughts help the community grow.