coders.sh *

Loading Developers Heaven

The Nearest Neighbor

Mission brief

Challenge Briefing

Easy

Sorting
LIMIT
Graph Traversal

A logistics company is optimizing its delivery routes. They need to find the single closest city that can be reached directly from their central distribution center, known as "Base". Your task is to identify this nearest neighbor and the numerical distance required to reach it.

The Nearest Neighbor

Identify the closest city reachable directly from a distribution center.

The Narrative

Schema Diagram

routes

originVARCHAR

destinationVARCHAR

distanceINT

Challenge a Friend

One SQL table. One SQL condition.
Still tricky for most developers.

SQL Editor

Terminal Output

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Try another challenge

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

View all

Title	Complexity	Status	Solve
The Ghost of 2020	Easy	Not solved	Solve
The Slow Query Hunt	Medium	Not solved	Solve
Deadlock Recovery	Easy	Not solved	Solve