Chamber 03 · Intake Corridor

The Sorting Pit

Rank by threat level

ORDER BY+35 XP

Locked

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

Briefing

Guards drag prisoners into the pit and sort them by danger. The warden wants the roster ordered from highest threat to lowest before the night shift.

Return name and threat_level from prisoners, sorted by threat_level descending.

ORDER BY column DESC puts the largest values first.

Chamber schema

prisoners4 cols

Prisoners rated by threat level

idnamethreat_levelcell

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