|
1
2
3
4
5
6
|
/*
Enter your query here.
Please append a semicolon ";" at the end of the query and enter your query in a single line to avoid error.
*/
select round(sqrt(power(min(LAT_N)-max(LAT_N), 2)+power(min(LONG_W)-max(LONG_W), 2)), 4)
from station
|
cs |
반응형
'SQL' 카테고리의 다른 글
| Hacker Rank Top Competitors (0) | 2022.03.29 |
|---|---|
| Hacker rank Weather Observation Station 20 (0) | 2022.03.29 |
| Hackerrank Weather Observation Station 18 (0) | 2022.03.29 |
| leetcode 627. Swap Salary (0) | 2022.03.17 |
| leetcode 620. Not Boring Movies (0) | 2022.03.17 |
댓글