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

|

1978 Discussions

|

  • douglasbarra11
     + 0 comments

    mysqlv ->

    select ceil(avg(salary) - avg(cast(replace(salary, 0, '') as decimal))) from employees

  • usabrock123
     + 0 comments

    MYSQL :-

    select CEIL(AVG(salary) - AVG(CAST(REPLACE(salary ,'0', '') AS UNSIGNED))) from employees ;

  • anw_g01
     + 0 comments
    SELECT CEIL(
    ABS(
        AVG(Salary) -   -- actual
        AVG(CAST(REPLACE(CAST(Salary AS CHAR), '0' , '') AS DECIMAL))   -- miscalculated
    )
) FROM EMPLOYEES;

  • godgod9542
     + 1 comment

    I submitted correct answer to MS SQL, but the answer to MS SQL was not accepted. After I wasted about a half hour, submitted the same code (the final output was 2253, exactly same) to My SQL as a test, it was immediately solved. Many other problem have simillar errors.

  • sairam2000sahoo
     + 0 comments

    select round(avg(salary) - avg(cast(replace(salary,0,'') as integer)))+1 from employees;