The Blunder

  • + 0 comments

    with cte as( select *, convert(float,replace((convert(varchar,salary)),'0','')) as new_column from employees ) select cast(ceiling(avg(cast(salary as float))-avg(new_column)) as int) from cte;