[MySQL] Hacker Rank 문제 연습 7

Top Earners (Aggregation)

• 

제출한 쿼리 :

SELECT (SALARY * MONTHS)
       , COUNT(*)
FROM EMPLOYEE
GROUP BY SALARY * MONTHS
ORDER BY SALARY * MONTHS DESC
LIMIT 1;

---

Weather Observation Station 13 (Aggregation)

• 

제출한 쿼리 :

SELECT ROUND(SUM(LAT_N), 4)
FROM STATION
WHERE LAT_N BETWEEN '38.7880' AND '137.2345';

---

Weather Observation Station 14 (Aggregation)

• 

제출한 쿼리 :

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

---

Weather Observation Station 15 (Aggregation)

• 

제출한 쿼리 :

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

---

Weather Observation Station 16 (Aggregation)

• 

제출한 쿼리 :

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

---