AVG in Sql - Float number problem

SELECT AVG(variable) AS Expr1, SUM(variable) AS Expr2 FROM ...... 

result for AVG is 2, but it is not true, it must be 2.95. What is the problem, any idea?

1 Answer

Try

Select AVG(Cast(variable as Float)), SUM(variable) From Table