Chamber 08 · Confiscation Vault

Paired Keys

Match locks to holders

INNER JOIN+55 XP

Locked

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

Briefing

The vault ring holds keys and doors in separate ledgers. Only pairs that truly fit belong on your map — unmatched locks are traps.

Return prisoner name and their assigned quest title by joining prisoners to quests (quests.assigned_to = prisoners.id), ordered by name then title.

INNER JOIN keeps only rows that match in both tables (quests.assigned_to = prisoners.id).

Chamber schema

prisoners2 cols

Prisoners who accepted quests

idname

quests5 cols

Active dungeon quests

idtitledifficultyxp_rewardassigned_to

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