Null Cardinal

Close the Null Cathedral

The Lockward seal waits. Five floors of queries stand behind you — one wrong result set and the gate stays shut.

BossWindowEXISTSNULLINNER JOINCOALESCEORDER BY+390 XP

Locked

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

Briefing

Final rite: clergy who attended mass (EXISTS), with known ordination, on open chapels — rank by tithe with NULL as zero.

Objective

Return clergy name, chapel name as chapel, and RANK() OVER (ORDER BY COALESCE(tithe, 0) DESC) as standing for clergy with ordination IS NOT NULL who EXISTS in attendance, on chapels where sealed = 0, ordered by standing.

Hint

Join chapels, EXISTS attendance, ordination IS NOT NULL, sealed = 0, COALESCE tithe in RANK(), ORDER BY standing.

Chamber schema

clergy5 cols

Clergy candidates for the cardinal rite

idnameordinationchapel_idtithe

chapels3 cols

Chapels and seal state

idnamesealed

attendance3 cols

Mass attendance proof

idclergy_idmass_on

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