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

|

1905 Discussions

|

  • baokhanh546123
     + 0 comments

    select ceil(abs(avg(salary) - avg(replace(salary , '0' , '')))) from employees

    You can try :))

  • chetannk1996
     + 0 comments

    below one giveing worng answer

    select ceil(avg(salary-TRIM(TRAILING '0' FROM salary))) from employees

  • ayush_kurchania
     + 1 comment

    SELECT ceil (ABS( (SELECT AVG(SALARY) FROM EMPLOYEES) - (SELECT AVG(CAST(REPLACE(SALARY, '0', '') AS UNSIGNED)) FROM EMPLOYEES) ))

  • Drose_gamer234
     + 1 comment

    Can anyone tell me where i can see all the key words (like REPLACE, CAST ..) used in the sql, the ones which are not present in tutorials from GFG, W3 etc?

  • pvj_valadares
     + 0 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