SQL/HackerRank

[HackerRank] The Blunder

yeyeyep 2025. 3. 7. 20:58

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT CEIL(AVG(Salary) - AVG(REPLACE(Salary, 0, ''))) AS Output
FROM EMPLOYEES

 

 

'SQL > HackerRank' 카테고리의 다른 글

[HackerRank] Weather Observation Station 2  (0) 2025.03.07
[HackerRank] Top Earners  (0) 2025.03.07
[HackerRank] Population Density Difference  (0) 2025.03.07
[HackerRank] Japan Population  (0) 2025.03.07
[HackerRank] Average Population  (0) 2025.03.07