You are viewing a single comment's thread. Return to all comments →
WITH sem_zeros AS ( SELECT Salary, CAST(REPLACE(CAST(Salary AS CHAR), "0", "") AS SIGNED) AS salario_limpo FROM EMPLOYEES ) SELECT ROUND(AVG(Salary) - AVG(salario_limpo)) + 1 AS dif_erro FROM sem_zeros
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 →