THE BLUNDER SQL HACKERRANK

[@immythic8351]

Thank you ma'am and Merry Christmas!

[@udayptp]

You cleared my doubt , I was using round function instead of ceil function. round(avg(salary) -avg(replace(salary, 0,''), 0) but I was getting error. Thanks

[@aashitanoah7464]

Haha, same!

[@garimakushwaha8465]

REPLACE is a string function and the type of the salary column is integer so why do we use the replace function? and here 0 is not a character of a string so how it can be replaced with an empty string?

[@bhuppidhamii]

THANK U, I WAS STUCK WITH PROBLEM FROM LONG TIME

[@SivaKumar-ef5oz]

I need complete SQL course serious

[@fazal179]

SIMPLE SOLUTION THANKS ...:)

[@Aysh_Sach_16-2]

also theory questions of DBMS?

[@sh4r9]

how to do that in ms sql server.. im getting error that Operand data type varchar is invalid for avg operator.

[@Avadhut-nd9yz]

/* This will do the trick for MS SQL server */
select ceiling(avg(salary) - avg(cast(replace(salary, 0,'') as int)))+1 from EMPLOYEES;

[@akashab]