8 lines
190 B
SQL
8 lines
190 B
SQL
-- Author: Rodney Shaghoulian
|
|
-- Github: github.com/RodneyShag
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
|
|
|
SELECT
|
|
CEIL(AVG(Salary) - AVG(REPLACE(SALARY, '0', '')))
|
|
FROM EMPLOYEES;
|