Chamber 27 · Undertow Archives

Brine Outer

LEFT JOIN in the undertow

LEFT JOIN+145 XP

Locked

Clear the previous chamber to unlock this one. You can still preview the briefing.

Briefing

Same LEFT JOIN idea as the Lockward crypts: list every route, even those with no relic yet.

Return route title and relic name (null when missing), ordered by route id.

LEFT JOIN relics ON relics.route_id = routes.id, then ORDER BY routes.id.

Chamber schema

routes2 cols

Every swim route

idtitle

relics3 cols

Relics tied to a route

idnameroute_id

chamber_27.sql

Results appear here after you run a query. Correct rows alone are not enough — the Warden must seal your loot.

Ask the Warden

AI SQL coach — hints and fail reviews, not spoilers

Warden

I am the Warden. Ask for a hint, paste a failing query, or request a review — I won't hand you the full answer.