HackerRank MySQL - Weather Observation Station 19


Query the Euclidean Distance between points P1 and P2 and format your answer to display 4 decimal digits.

  1. SELECT ROUND(SQRT(POWER(MIN(LAT_N) - MAX(LAT_N), 2) + POWER(MIN(LONG_W) - MAX(LONG_W), 2)), 4)
  2. FROM STATION;

download android app