Data Dungeon
← Index Spire

Chamber 36 · Catalog Wing

Coalesce Plaque

Fill NULL labels

COALESCE+180 XP
Locked

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

Briefing

NULL handling returns from Forgotten Cells. COALESCE picks a fallback subtitle when dust ate the carving.

Objective

Return title and COALESCE(subtitle, 'Blank') as subtitle, ordered by id.

Hint

COALESCE(a, b) returns the first non-NULL value.

Chamber schema

plaques3 cols

Catalog plaques with optional subtitles

idtitlesubtitle
chamber_36.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.