Lockward Seal

Close the first section

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

BossEXISTSNULLINNER JOINWHEREORDER BY+150 XP

Locked

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

Briefing

The Lockward's final seal demands proof: heroes who still hold a key, whose crime is known (not null), ranked by the gold on their legendary haul.

Return name and gold for prisoners who EXISTS in keys, have a non-null crime, and own legendary loot — ordered by gold descending.

Combine EXISTS (keys), crime IS NOT NULL, rarity = 'legendary', then ORDER BY gold DESC.

Chamber schema

prisoners4 cols

Candidates for the Lockward seal

idnamecrimeclass

keys3 cols

Keys still in circulation

idkey_nameholder_id

loot4 cols

Personal hauls by prisoner

prisoner_iditemgoldrarity

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