We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
WITH tb AS (
SELECT
MAX(LAT_N) AS c,
MIN(LAT_N) AS a,
MAX(LONG_W) AS d,
MIN(LONG_W) AS b
FROM STATION
)
SELECT CAST(ROUND(ABS(a -c)+ABS(b - d),4) AS DECIMAL(10,4)) as Manhattan_Distance
FROM tb;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 18
You are viewing a single comment's thread. Return to all comments →
WITH tb AS ( SELECT MAX(LAT_N) AS c, MIN(LAT_N) AS a, MAX(LONG_W) AS d, MIN(LONG_W) AS b FROM STATION ) SELECT CAST(ROUND(ABS(a -c)+ABS(b - d),4) AS DECIMAL(10,4)) as Manhattan_Distance FROM tb;