Chamber 13 · Ashen Depths

Risk Brands

Stamp the threat class

CASE+75 XP

Locked

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

Briefing

The ash-river clerks brand each prisoner before the ferry. Classify: threat 4+ is 'high', 2–3 is 'mid', otherwise 'low'.

Return name, threat_level, and a risk column from a CASE expression ('high' / 'mid' / 'low'), ordered by name.

CASE WHEN … THEN … WHEN … THEN … ELSE … END builds a derived column.

Chamber schema

prisoners4 cols

Prisoners with threat ratings

idnamethreat_levelcell

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