728x90
반응형
문제 :
Query the following two values from the STATION table:
- The sum of all values in LAT_N rounded to a scale of decimal places.
- The sum of all values in LONG_W rounded to a scale of decimal places.
SELECT ROUND(SUM(LAT_N), 2) AS lat, ROUND(SUM(LONG_W),2) AS lon
FROM STATION;
42850.04 47381.48
728x90
반응형
'DB > SQL' 카테고리의 다른 글
HackerRank_10. Weather Observation Station 4 (0) | 2020.06.11 |
---|---|
HackerRank_09. Weather Observation Station 3 (0) | 2020.06.11 |
HackerRank_07.Weather Observation Station 1 (0) | 2020.06.11 |
HackerRank_06. Japanese Cities' Names (0) | 2020.06.11 |
HackerRank_05.Japanese Cities' Attributes (0) | 2020.06.11 |