Top Earners
SELECT (MONTHS * SALARY) AS TOTAL_EARNINGS, COUNT(*)
FROM EMPLOYEE
GROUP BY TOTAL_EARNINGS
ORDER BY TOTAL_EARNINGS LIMIT 1;
SQL
복사
Weather Observation Station 2
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2)
FROM STATION
SQL
복사
Weather Observation Station 13
SELECT ROUND(SUM(LAT_N), 4)
FROM STATION
WHERE LAT_N > 38.7880 AND LAT_N < 137.2345;
SQL
복사
Weather Observation Station 14
SELECT ROUND(LAT_N, 4) AS MAX_LAT_N
FROM STATION
WHERE LAT_N < 137.2345
GROUP BY MAX_LAT_N
ORDER BY MAX_LAT_N DESC LIMIT 1;
SQL
복사
Weather Observation Station 15
SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N < 137.2345
ORDER BY LAT_N DESC LIMIT 1;
SQL
복사
Weather Observation Station 16
SELECT ROUND(LAT_N, 4)
FROM STATION
WHERE LAT_N > 38.7780
ORDER BY LAT_N ASC LIMIT 1;
SQL
복사
Weather Observation Station 17
SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N > 38.7780
ORDER BY LAT_N LIMIT 1;
SQL
복사
Weather Observation Station 18
SELECT ROUND(ABS(MIN(LAT_N) - MAX(LAT_N)) + ABS(MIN(LONG_W) - MAX(LONG_W)), 4)
FROM STATION;
SQL
복사
Weather Observation Station 19
•
(a,b)
◦
MIN LAT_N
◦
MAX LAT_N
•
(c,d)
◦
MIN LONG_W
◦
MAX LONG_W
SELECT ROUND(SQRT(POW(ABS(MIN(LAT_N) - MAX(LAT_N)), 2) + POW(ABS(MIN(LONG_W) - MAX(LONG_W)), 2)), 4)
FROM STATION;
SQL
복사
Weather Observation Station 20
SELECT ROUND(LAT_N, 4)
FROM (
SELECT LAT_N, PERCENT_RANK() OVER (ORDER BY LAT_N ASC) P
FROM STATION
) MEDIAN
WHERE P = 0.5;
SQL
복사