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
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;