The Blunder

  • + 0 comments

    select ceil(avg(salary) - avg(replace(salary,'0',''))) from employees

    here if we use round it will round the number to nearest whole number, that's why we use ceil. so it will round the element to nearest integer.