You are viewing a single comment's thread. Return to all comments →
SELECT CAST(CEILING(AVG(CAST(Salary AS FLOAT))-AVG(CAST(REPLACE(Salary, 0, '') as FLOAT))) AS INTEGER) from EMPLOYEES;
Seems like cookies are disabled on this browser, please enable them to open this website
The Blunder
You are viewing a single comment's thread. Return to all comments →
SELECT CAST(CEILING(AVG(CAST(Salary AS FLOAT))-AVG(CAST(REPLACE(Salary, 0, '') as FLOAT))) AS INTEGER) from EMPLOYEES;