[SQL문제풀기] The Blunder

문제

The Blunder | HackerRank

Query the amount of error in Sam's result, rounded up to the next integer.

https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true

MySQL

내가 작성한 정답

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

Oracle

내가 작성한 정답

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

MS SQL Server

내가 작성한 오답

select ceiling(avg(salary) - avg(cast(replace(salary,'0','') as decimal)))
from employees;

내가 작성한 정답

select ceiling(avg(cast(salary as decimal)) - avg(cast(replace(salary,'0','') as decimal)))
from employees;

DB2

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

select avg(cast(salary as decimal))-avg(replace(salary,'0',''))
from employees;

내가 작성한 정답

select ceiling(avg(cast(salary as decimal))-avg(replace(salary,'0','')))
from employees;

정리!