[HackerRank](E) Weather Observation Station 2

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

Weather Observation Station 2 | HackerRank

 

[문제]

Query the following two values from the STATION table:

1. The sum of all values in LAT_N rounded to a scale of  decimal places.
2. The sum of all values in LONG_W rounded to a scale of  decimal places.

Input Format

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

 

[답]

-mysql

select round(sum(lat_n),2), round(sum(long_W),2)
from station

각각 위도와 경도 값을 모두 더해서 소수점 2째자리까지 반올림 해주면 된다.