[HackerRank] Weather Observation Station 13

😅 문제 출처

 

https://www.hackerrank.com/challenges/weather-observation-station-13/problem?isFullScreen=true 

Weather Observation Station 13 | HackerRank

---

1️⃣ 문제

38.7880보다 크고 137.2345보다 작은 값을 가진 STATION의 Northern Latitude(LAT_N) 합계를 쿼리합니다. 소수점 4자리로 답을 잘라냅니다.

 

2️⃣ MySQL 쿼리

select truncate(sum(LAT_N),4)
from station
where LAT_N > 38.7880
  and LAT_N < 137.2345;

 

 

---

Run Code 버튼 클릭 시,

 

Submit Code 버튼 클릭 시,