Chamber 12 · Ashen Depths

Tithe Threshold

Only rich guilds pass

HAVINGGROUP BY+70 XP

Locked

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

Briefing

The ash-river ferry demands a tithe. Only guilds whose confiscated gold totals more than 50 may cross — the poor stay in the shallows.

Return guild_name and total gold (as total_gold) for guilds whose SUM(gold) is greater than 50, ordered by guild_name.

HAVING filters groups after GROUP BY — unlike WHERE, which filters rows first.

Chamber schema

loot4 cols

Confiscated treasure by guild

iditemgoldguild_name

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