Discussion on Weather Observation Station 18 Challenge

Sort 1615 Discussions, By:

5 hours ago+ 0 comments

MySQL

SELECT 
ROUND((MAX(Lat_N)-MIN(Lat_N))+(MAX(Long_W)-MIN(Long_W)), 4) 
From Station;

1 day ago+ 0 comments

SELECT 
ROUND(ABS(MIN(LAT_N)-MAX(LAT_N))+ABS(MIN(LONG_W)-MAX(LONG_W)),4) 
FROM STATION;

1 day ago+ 1 comment

What is wrong with this code? I tried to use pythagorean theorem.

select round(sqrt(power(max(LAT_N)-min(LAT_N), 2) + power(max(LONG_W)-min(LONG_W), 2)), 4) from station;

2 days ago+ 0 comments

SELECT ROUND((abs(MIN(LAT_N) - MAX(LAT_N)) + abs(MIN(LONG_W) - MAX(LONG_W))),4) 
    FROM STATION;

2 days ago+ 0 comments

Applying the equation for Manhattan Distance: |x^1 - x^2| + |y^1 - y^2|

SELECT ROUND((ABS(MIN(LAT_N) - MAX(LAT_N)) + ABS(MIN(LONG_W) - MAX(LONG_W))), 4)
FROM STATION;