Closest Pair of Sensor Stations

Problem

An environmental network places sensor stations on a coordinate grid.

```
SensorStation
+--------+------+
| Column | Type |
+--------+------+
| east | int |
| north | int |
+--------+------+
(east, north) is the primary key; no two stations share a location.
```

Report the shortest straight-line (Euclidean) distance between any two distinct stations, rounded to 2 decimal places. Name the output column `nearest`.

The distance between (east1, north1) and (east2, north2) is sqrt((east1-east2)^2 + (north1-north2)^2).

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns nearest.

Starter code (SQL)

SELECT *
FROM SensorStation;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium