2008R2 How do I average the total scores summed?

Question

How do I do the Average in this coding?

Sum(qa.greeting1+qa.greeting2+qa.greeting3+qa.greeting5+qa.greeting6) as AverageTotalCareScore

Thank you!

Answer 1

It sounds like you have a query already for a result set (100 rows?) so I would suggest doing something like a CTE to find the average of a result set.

WITH CTE AS(
<your query here>
)
SELECT 
AVG(column_to_be_averaged)
FROM CTE

Unless I misunderstood something, this should work out.

Answer 2

To calculate the average you can simply do like this:

select (qa.greeting1+qa.greeting2+qa.greeting3+qa.greeting5+qa.greeting6)/5

ie, sum of all the items divided by the number of items.

You can also use the AVG() function in SQL Server like this:

select AVG(column1)