Chamber 28 · Twin Currents

Mirror Tide

Self-join mentors

Self JOIN+150 XP

Locked

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

Briefing

New shape: join a table to itself. Pair each apprentice with their mentor's name.

Return apprentice and mentor names via self-join on mentor_id, ordered by apprentice.

JOIN divers AS mentor ON mentor.id = apprentice.mentor_id.

Chamber schema

divers3 cols

Divers with optional mentors

idnamementor_id

chamber_28.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.