Chamber 11 · Ashen Depths
Echo Gallery
Hear each crime once
DISTINCT+65 XP
Locked
Clear the previous chamber to unlock this one. You can still preview the briefing.
Briefing
Whispers bounce off the gallery walls — every crime shouted twice, thrice. The archivist wants each distinct crime written once on the slate.
Objective
Return each unique crime from the prisoners table, ordered alphabetically.
Hint
SELECT DISTINCT column removes duplicate values.
Chamber schema
prisoners4 colsRoster with repeated crime labels
idnamecrimecell
chamber_11.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.