Chamber 17 · Gate of Seals

Proof of Presence

Who still holds a torch

EXISTS+90 XP

Locked

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

Briefing

Only prisoners who still appear in the torch log may approach the seal. Prove presence with EXISTS — no half-measures.

Return prisoner name for those who have at least one row in torch_log (via EXISTS), ordered by name.

EXISTS (SELECT 1 FROM … WHERE …) is true when the subquery finds any row.

Chamber schema

prisoners3 cols

All known prisoners

idnamecell

torch_log3 cols

Recent torch sightings by prisoner

idprisoner_idseen_on

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