Chamber 44 · Structure Vault

Window Join

Rank after joining

WindowINNER JOIN+235 XP

Locked

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

Briefing

Join climbers to floors, then ROW_NUMBER by score — window after join, Lockward habit plus Spire tool.

Return climber name, floor name as floor_name, and ROW_NUMBER() OVER (ORDER BY score DESC) as rung, ordered by rung.

INNER JOIN floors, window ROW_NUMBER on score, ORDER BY rung.

Chamber schema

climbers4 cols

Climbers on floors

idnamescorefloor_id

floors2 cols

Spire floor names

idname

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