Data Dungeon
← The Lockward

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 cols

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