[MySql] HackerRank challenges - BASIC 2

The Blunder

• 기존 월평균 급여 - 0 제거한 월 평균
• 점수 올림 -> ceil (올림 함수)

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

 

Top Earners

SELECT (salary*months) AS earnings, COUNT(*)
FROM EMPLOYEE
GROUP BY earnings
ORDER BY earnings DESC LIMIT 1;

 

Weather Observation Station 2

SELECT ROUND(SUM(LAT_N),2), ROUND(SUM(LONG_W),2)
FROM STATION;

 

Weather Observation Station 13

SELECT ROUND(SUM(LAT_N),4)
FROM STATION
WHERE LAT_N>38.7880 AND LAT_N<137.2345;

 

Weather Observation Station 14

• 소수점 4자리, 최대값

SELECT ROUND(MAX(LAT_N),4) FROM STATION
WHERE LAT_N < 137.2345;

 

Weather Observation Station 15

• 137.2345보다 작고 그 중 최대값 LAT_N의 LONG_W 4자리 수

SELECT ROUND(LONG_W,4) FROM STATION
WHERE LAT_N < 137.2345
ORDER BY LAT_N DESC LIMIT 1;

 

Weather Observation Station 16

SELECT ROUND(MIN(LAT_N),4) FROM STATION
WHERE LAT_N > 38.7780;

 

Weather Observation Station 17

SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N > 38.7780
ORDER BY LAT_N ASC LIMIT 1;