AVG in Sql - Float number problem

Question

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?

Answer 1

SELECT AVG(CAST(age)) AS average_age FROM Customer C JOIN Purchase P1 USING (customer_key) JOIN Product P USING (product_key) WHERE P.name = 'Smartwatch' AND YEAR(date) = 2024

Answer 2

Try

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