Chamber 59 · Cardinal Void

Cardinal Prelude

COALESCE, IN, IS NOT NULL

COALESCENULLIN+365 XP

Locked

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

Briefing

Warmup before the Cardinal: ordained clergy in ranks A or B, with COALESCE on missing titles.

Return name and COALESCE(title, 'Cleric') as title where ordination IS NOT NULL AND rank_code IN ('A', 'B'), ordered by name.

IS NOT NULL on ordination, IN ('A','B'), COALESCE title, ORDER BY name.

Chamber schema

clergy5 cols

Clergy at the cardinal void

idnametitlerank_codeordination

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