You are viewing a single comment's thread. Return to all comments →
MYSQL Query
SELECT ROUND(AVG(SALARY)) - ROUND(AVG(REPLACE(SALARY,0,''))) FROM EMPLOYEES;
MS MYSQL Query
SELECT ROUND(AVG(SALARY), 0) - ROUND(AVG(CAST(REPLACE(SALARY, '0', '') AS FLOAT)), 0) AS SALARY_DIFFERENCE 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 →
MYSQL Query
SELECT ROUND(AVG(SALARY)) - ROUND(AVG(REPLACE(SALARY,0,''))) FROM EMPLOYEES;
MS MYSQL Query
SELECT ROUND(AVG(SALARY), 0) - ROUND(AVG(CAST(REPLACE(SALARY, '0', '') AS FLOAT)), 0) AS SALARY_DIFFERENCE FROM EMPLOYEES;