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

|

2132 Discussions

|

  • empoweryourself1
     + 1 comment

    Looks like the test case is off? I consistently got 2252, but accroding to the checker the answer is supposed to be 2253.

  • ravi456cr
     + 0 comments

    SELECT CEIL( AVG(salary) - AVG(REPLACE(salary, '0', '')) ) FROM EMPLOYEES;

  • hikimiko01
     + 0 comments
    SELECT CEIL(AVG(SALARY) - AVG(REPLACE(SALARY, "0", "")))
FROM EMPLOYEES

  • fabricio_2310
     + 0 comments
    MYSQL: 
    SELECT CEIL(
    AVG(salary) - AVG(CAST(REPLACE(CAST(salary AS CHAR), '0', '') AS SIGNED))
    )
FROM employees;

  • dpkraj1115
     + 0 comments

    MS SQL SERVER

    SELECT
cast(
    Ceiling(
        
        avg(cast(salary as float))
        -
        avg( cast(replace(cast(salary as varchar(20)),'0','') as float) )
        
        )
     
as int)
FROM Employees