The Blunder

  • + 0 comments

    MS SQL SERVER

    SELECT
    cast(
        Ceiling(
            
            avg(cast(salary as float))
            -
            avg( cast(replace(cast(salary as varchar(20)),'0','') as float) )
            
            )
         
    as int)
    FROM Employees