The Blunder

  • + 0 comments
    SELECT CEIL(
        ABS(
            AVG(Salary) -   -- actual
            AVG(CAST(REPLACE(CAST(Salary AS CHAR), '0' , '') AS DECIMAL))   -- miscalculated
        )
    ) FROM EMPLOYEES;