We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. The Blunder
  5. Discussions

The Blunder

Sort by

recency

|

1878 Discussions

|

  • ks2018111
     + 0 comments

    SELECT CEIL(ABS( (SELECT AVG(salary) FROM EMPLOYEES) - (SELECT AVG(CAST(REPLACE(CAST(salary AS CHAR), '0', '') AS UNSIGNED)) FROM EMPLOYEES) )) AS error_difference;

    -- For MySQL

  • kannemadugumahe1
     + 0 comments

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

  • mukherjeerick347
     + 0 comments

    select round(avg(Salary))-round(avg(replace(Salary,'0',''))) from EMPLOYEES;

  • ripachakrabarty1
     + 0 comments

    SELECT CEIL(AVG(SALARY)-AVG(REPLACE(SALARY,0,''))) AS DIFFERENCE FROM EMPLOYEES;

  • manpreetkaur6136
     + 0 comments

    Select ROUND(AVG(SALARY))-ROUND(AVG(REPLACE(SALARY,'0',''))) FROM EMPLOYEES