Nearest Point Pair Distance in 2D

You are given a table named Point2D where each row is a unique point on a Cartesian plane.

Schema:

• x: integer x-coordinate
• y: integer y-coordinate

The pair (x, y) is unique across the table.

Define the Euclidean distance between two points (x1, y1) and (x2, y2) as:

• sqrt((x2 - x1)^2 + (y2 - y1)^2)

Task:

• Compute the minimum distance between any two distinct points.
• Return exactly one column named shortest.
• Round the output to two decimal places.

This problem should be solved in both:

• SQL (SQLite 3.27.2)
• Pandas

Point2D:
| x  | y  |
|----|----|
| -1 | -1 |
| 0  | 0  |
| -1 | -2 |

[
  {"shortest":1.0}
]

Point2D:
| x | y |
|---|---|
| 0 | 0 |
| 1 | 1 |
| 4 | 4 |

[
  {"shortest":1.41}
]

Point2D:
| x  | y |
|----|---|
| -5 | 2 |
| -1 | 2 |
| 2  | 5 |
| 2  | 6 |

[
  {"shortest":1.0}
]