I'm solving a hacker rank challenges and i'm stuck with an error
Msg 8117, Level 16, State 1, Server WIN-ILO9GLLB9J0, Line 2
Operand data type varchar is invalid for avg operator.
kindly suggest the chnages
I have tried writing this query
SELECT CEILING((AVG(Salary))-(AVG(REPLACE(Salary,0,'')))) FROM EMPLOYEES