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

|

2143 Discussions

|

  • nguyenhuydungcn1
     + 0 comments

    SELECT CEIL(AVG(CAST(Salary AS DOUBLE)) - AVG(CAST(REPLACE(CAST(Salary AS CHAR),'0','') AS DOUBLE))); FROM EMPLOYEES; ??? Why it's wrong

  • joeljones013
     + 0 comments

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

    This works...

  • dinhcaohuan117
     + 0 comments

    with raw AS ( select avg(Salary) as actual ,avg(cast(replace(Salary,'0','') as SIGNED)) as mis_calculated from EMPLOYEES )

    select ceil(actual - mis_calculated) from raw

  • reggierumbu
     + 0 comments

    SELECT CEIL(AVG(Salary) - AVG(CAST(REPLACE(CAST(SALARY AS CHAR),'0','') AS UNSIGNED))) FROM EMPLOYEES;

  • mohammmedsamiud1
     + 0 comments

    SELECT CAST( CEILING( AVG(CAST(salary AS FLOAT)) - AVG(CAST(REPLACE(CAST(salary AS VARCHAR(20)), '0', '') AS FLOAT)) ) AS INT ) FROM employees;