Chamber 02 · Intake Corridor

Torchlight Archive

Name only what you need

Columns+30 XP

Briefing

The archive is vast, but your torch is weak. The warden's log has dozens of fields — you only need the prisoner names and their cell numbers to find your route.

Objective

Return only the name and cell columns from prisoners, in that order.

Hint

List column names after SELECT instead of using *.

Chamber schema

prisoners5 cols

Prison roster with full records

idnamecellcrimearrested_on

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