MySQL

SELECT CEILING(AVG(SALARY) - AVG(REPLACE(SALARY,'0','')))
FROM EMPLOYEES

SQL Server The problem here is that AVG() returns an integer when used on integers. So the result will be wrong. You have to convert the values to float before using AVG(). This worked for me:

select
    cast(ceiling(avg(cast(salary as float)) - avg(cast(replace(convert(varchar(5), salary), "0", "") as float))) as int)
from employees

SELECT CEILING ((AVG (salary)) - AVG (REPLACE (salary,0,""))) AS avg_sal FROM EMPLOYEES

SELECT CEILING ((AVG (salary)) - AVG (REPLACE (salary,0,""))) AS avg_sal FROM EMPLOYEES

MS SQL SEVER: - Salary : INT => AVG Salary: INT > FLOAT - REPLACE (salary,0,""): VARCHAR > FLOAT - CEILING: FLOAT => NUMERIC OR INT

SELECT CAST (CEILING (AVG (CAST (salary AS FLOAT)) - AVG (CAST(REPLACE (salary,0,"") AS FLOAT))) AS NUMERIC) FROM EMPLOYEES