troubleshooting Question

SQL Removing an average from SQL

Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2008
4 Comments1 Solution414 ViewsLast Modified:
Hi. I am trying to take the average out of this SQL statement but get various errors. How would the statement look without the averaging? Thanks


SELECT Categories.[Sub Category] As Result, Round(avg((CAST([Score] as Float) / 5 * 100)), 2) AS Score FROM Answers LEFT JOIN Categories ON Answers.Category = Categories.ID GROUP BY Categories.[Main Category], Categories.[Sub Category], Answers.Survey, Answers.ReviewerID, Answers.CompanyID HAVING (((Categories.[Main Category])='INTERPERSONAL') AND ((Answers.Survey)='1') AND ((Answers.ReviewerID)='R') AND ((Answers.CompanyID)='XYZ')) Order By Result
ASKER CERTIFIED SOLUTION
AdamCz

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros