[HackerRank SQL] The Blunder

문제 link
https://www.hackerrank.com/challenges/the-blunder/problem

Code link
https://github.com/JamesJung01/Hackerrank_sql/blob/main/01_Easy/The_Blunder.sql

Case 1

SELECT ROUND(AVG(SALARY),0) - ROUND(AVG(REPLACE(SALARY,0,'')),0)
FROM EMPLOYEES;

Case 2

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