Chamber 50 · Absence Choir

Orphan Pews

LEFT JOIN + IS NULL

LEFT JOINNULL+290 XP

Locked

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

Briefing

Same LEFT JOIN idea as the Lockward crypts — list every pew, then keep only those with no occupant.

Return pew label for pews with no occupant (occupant name IS NULL), ordered by label.

LEFT JOIN occupants, WHERE occupants.name IS NULL, ORDER BY label.

Chamber schema

pews2 cols

Every pew in the choir

idlabel

occupants3 cols

Who sits in each pew

idnamepew_id

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