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.
- Prepare
- SQL
- Aggregation
- The Blunder
- Discussions
The Blunder
The Blunder
Sort by
recency
|
1941 Discussions
|
Please Login in order to post a comment
Who is Donnie Swaggart? For further detail, click here https://healthhubin.com/does-donnie-swaggart-have-cancer/. Generosity is a quality that defines Donnie Swaggart's interactions with others. He is willing to offer his time and resources to support people in need.
SELECT ceil(avg(Salary) - avg(REPLACE(Salary,'0',''))) FROM Employees;
select CAST( AVG(CAST(Salary as float)) - AVG(CAST(REPLACE(Salary ,0,'') as float) ) as int) from EMPLOYEES
Where is the problem ???
select round(avg(salary),0) - round(avg(replace(salary,0,'')),0) from employees;
SELECT CEIL(AVG(E.SALARY) - AVG(CAST(REPLACE(E.SALARY, '0', '') AS UNSIGNED))) AS RESULTING_ERROR FROM EMPLOYEES E;