search

RodneyShag / HackerRank_solutions

317 efficient solutions to HackerRank problems
MIT License
2.69k stars 1.44k forks source link

Delete The Blunder.sql #42

Open Hari5g5 opened 2 years ago

Hari5g5 commented 2 years ago

SELECT CAST(CEILING((AVG(CAST(Salary AS Float)) - AVG(CAST(REPLACE(Salary, 0, '')AS Float)))) AS INT) FROM EMPLOYEES;