Chamber 53 · Integrity Crypt

Excommunicate

NOT IN

INSubquery+315 XP

Locked

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

Briefing

IN is Index Spire knowledge. NOT IN excludes the excommunicated — who may still serve?

Return name from clergy where id NOT IN (SELECT id FROM excommunicated), ordered by name.

WHERE id NOT IN (SELECT id FROM excommunicated), ORDER BY name.

Chamber schema

clergy3 cols

All clergy in the crypt

idnamerank

excommunicated3 cols

Clergy struck from the roll

idnamestruck_on

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