The Blunder

Sort by

recency

|

2088 Discussions

|

  • + 0 comments

    ORACLE

    SELECT CEIL(AVG(SALARY)-AVG(TO_NUMBER(REPLACE(TO_CHAR(SALARY),'0','')))) FROM EMPLOYEES;

  • + 0 comments

    MS SQL

    SELECT 
        CAST(
            CEILING(
                AVG(CAST(SALARY AS FLOAT)) - 
                AVG(CAST(REPLACE(CAST(SALARY AS VARCHAR), '0', '') AS FLOAT))
            ) AS INT
            ) AS SamanthaDiff 
    FROM EMPLOYEES;
    
  • + 0 comments

    SELECT ceiling(AVG((salary) - CAST(REPLACE(CAST(salary AS VARCHAR), '0', '') AS Numeric))) FROM Employees;

  • + 1 comment

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

  • + 0 comments

    SELECT CEILING(AVG(sal.actual - sal.fake)) AS blunder FROM ( SELECT CEILING(SALARY) AS actual, ROUND(CEILING(CAST(REPLACE(SALARY, '0', '') AS UNSIGNED))) AS fake FROM EMPLOYEES ) AS sal;