/* Enter your query here. */ SELECT ROUND(SQRT(POW(MIN(LAT_N)-MAX(LAT_N),2)+POW(MIN(LONG_W )-MAX(LONG_W),2)),4) FROM STATION;

/* Enter your query here. */ SELECT ROUND(SQRT(POW(MIN(LAT_N)-MAX(LAT_N),2)+POW(MIN(LONG_W )-MAX(LONG_W),2)),4) FROM STATION;

Select CAST(round(sqrt(power(max(LAT_N)-min(LAT_N),2)+power(max(LONG_W)-min(LONG_W),2)),4) as numeric(12,4)) from STATION

MySQL

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