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

|

2023 Discussions

|

  • makkprog1
     + 0 comments

    WITH REFINED_TABLE AS ( SELECT *, REGEXP_REPLACE(SALARY,0,"") AS NAKED_SALARY FROM EMPLOYEES ) SELECT CEIL(AVG(SALARY) - AVG(NAKED_SALARY)) AS DIFF FROM REFINED_TABLE

  • mj14jagtap
     + 0 comments

    select cast(avg(salary) as SIGNED) - cast(avg(replace(salary,'0','')) as SIGNED) from EMPLOYEES ;

    Simple query for mysql workbench user;

  • nguyenhongphuc23
     + 0 comments

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

  • bzioumohamedmou1
     + 0 comments
    SELECT CEIL(AVG(SALARY)-AVG(CAST(REPLACE(Salary, '0', '') AS UNSIGNED))) FROM EMPLOYEES;

  • dikshasaindane88
     + 0 comments

    MySQL :

    SELECT CEIL((SELECT AVG(salary) FROM EMPLOYEES) - (SELECT AVG(CAST(REPLACE(Salary,'0','')AS UNSIGNED)) FROM EMPLOYEES)) As amount_of_error;