# HackerRank SQL

# Weather Observation Station 19

Problem:

Consider P1(a, c) and P2(b,d) to be two points on a 2D plane where a, c are the respective minimum and maximum values of Northern Latitude (LAT_N) and b, d are the respective minimum and maximum values of Western Longitude (LONG_W) in **STATION**.

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

**Input Format**

The **STATION** table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

To-Do:

Check how to calculate Euclidean distance, and Power(, 2) is the syntax for power of 2. Round(, 4) is the syntax for rounding to 4 decimal point.

Solution:

`select round(sqrt(power(max(LAT_N) - min(LAT_N), 2) + power(max(LONG_W) - min(LONG_W), 2)), 4)`

FROM STATION;