Keyholder Throne

Who still holds a vault key

The air thins. Torchlight dies to embers. One wrong result set and the vault stays sealed.

BossSubqueryINNER JOINORDER BY+120 XP

Locked

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

Briefing

The Keyholder Throne only opens for prisoners who still carry a vault key. Find those whose id appears among key holders, join their active quest, and rank by quest XP.

Objective

Return prisoner name and quest title for prisoners who hold a key (id IN keys.holder_id), ordered by quest xp_reward descending, then name.

Hint

Filter with WHERE id IN (SELECT holder_id FROM keys), then ORDER BY xp_reward DESC.

Chamber schema

prisoners3 cols

Adventurers in the ash depths

idnameclass

keys3 cols

Vault keys and who holds them

idkey_nameholder_id

quests4 cols

Quests assigned to heroes

idtitlexp_rewardassigned_to

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