[Hacker Ranker] 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 2 decimal places.
2. The sum of all values in LONG_W rounded to a scale of 2 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.

Output Format

Your results must be in the form:

lat lon

 

where LAT  is the sum of all values in LAT_N and LON is the sum of all values in LONG_W. Both results must be rounded to a scale of 2 decimal places.

 

 

[My Answer]

SELECT 
ROUND(SUM(LAT_N),2),
ROUND(SUM(LONG_W), 2)
FROM STATION

좌표찍는것 문제. 

ROUND를 통해서 소수점 정해주고 그 안에 sum(value)