Vault Warden

The confiscation master ledger

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

BossINNER JOINWHEREORDER BY+100 XP

Locked

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

Briefing

The Vault Warden keeps the master ledger: prisoners, their quests, and legendary seized loot. One query opens the iron door — filter, join, and rank the haul.

Objective

Return hero name, quest title, and gold for legendary loot only, ordered by gold descending.

Hint

Chain JOINs across three tables, filter rarity, then ORDER BY gold DESC.

Chamber schema

prisoners3 cols

Adventurers in the vault

idnameclass

quests3 cols

Quests tied to each hero

idtitleassigned_to

loot4 cols

Treasure from completed quests

quest_iditemgoldrarity

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