sql notes: hackerrank weather observation station 19

Problem

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

Query the Euclidean Distance between points P₁ and P₂ and format your answer to display 4 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.

Analysis

The Euclidean Distance is sqrt((a-b)² + (c-d)²)

• Euclidean Distance ==> SQRT(POW(MIN(LAT_N)-MAX(LAT_N), 2) + POW(MIN(LONG_W)-MAX(LONG_W), 2))
• round answer to 4 decimal places ==> SELECT ROUND(SQRT(POW(MIN(LAT_N)-MAX(LAT_N), 2) + POW(MIN(LONG_W)-MAX(LONG_W), 2)), 4)
• in STATION table ==> FROM STATION

Solution

1

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

Link

Weather Observation Station 19
(中文版) SQL 笔记: Hackerrank Weather Observation Station 19