728x90
[해커랭크] Weather Observartion Station 19
https://www.hackerrank.com/challenges/weather-observation-station-19/problem?isFullScreen=true
Weather Observation Station 19 | HackerRank
Query the Euclidean Distance between two points and round to 4 decimal digits.
www.hackerrank.com
이 문제 어렵다 ..
참고 블로그
https://blog.naver.com/pbgg8002/222966978246
[SQL 오답노트] HackerRank 문제 풀이 18 (Weather Observation Station 19)
Weather Observation Station 19 *원문* Consider P1(a,c) and P2(b,d) to be two points on a 2D p...
blog.naver.com
- POWER(숫자값, 승수값)
- 제곱근을 표현하는 함수
- POWER(2,4) : 2의 4제곱을 표현
- SQRT(숫자값)
- 루트값 표현하는 함수
- SQRT(2) = √2
select round(SQRT(power(max(LONG_W) - min(LONG_W), 2) + power(max(LAT_N) - min(LAT_N), 2)), 4)
from station728x90
'SQL' 카테고리의 다른 글
| [해커랭크] Binary Tree Nodes (0) | 2023.07.23 |
|---|---|
| [해커랭크] Weather Observation Station 20 (0) | 2023.07.21 |
| [해커랭크] Weather Observation Station 18 (0) | 2023.07.21 |
| [해커랭크] The PADS (0) | 2023.07.20 |
| [해커랭크] Draw The Triangle 2 (0) | 2023.07.20 |