Chamber 56 · Fractured Transept

Hollow Join

LEFT JOIN + COALESCE

LEFT JOINCOALESCE+340 XP

Locked

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

Briefing

Every saint must appear — even those with no assigned chapel. Fill missing chapel names with 'Unassigned'.

Return saint name and COALESCE(chapel, 'Unassigned') as chapel via LEFT JOIN, ordered by saint name.

LEFT JOIN chapels, COALESCE the chapel column, ORDER BY saints.name.

Chamber schema

saints3 cols

Cathedral saints

idnamechapel_id

chapels2 cols

Chapel names

idchapel

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