728x90
https://www.hackerrank.com/challenges/weather-observation-station-2/problem
Weather Observation Station 2 | HackerRank
Write a query to print the sum of LAT_N and the sum of LONG_W separated by space, rounded to 2 decimal places.
www.hackerrank.com
[problem]
[analysis]
1. SUM 이용
2. ROUND(컬럼명/값,n) 값을 소수점이하 n자리수로 반올림
[solution]
728x90
'MS SQL > MS SQL : HackerRank' 카테고리의 다른 글
| MS SQL- HackerRank Japan Population(sum, where) (0) | 2022.04.25 |
|---|
