Chamber 07 · Warden's Wing

Seized Ledger

Tally confiscated gold by guild

GROUP BY+50 XP

Locked

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

Briefing

The confiscation desk tags every seized purse by thieves' guild. The warden wants total gold per guild on one ironbound report.

Return guild_name and the sum of gold for each guild from the loot table, ordered by guild_name.

GROUP BY clusters rows; SUM() adds values inside each cluster.

Chamber schema

loot4 cols

Confiscated treasure by guild

iditemgoldguild_name

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