Chamber 39 · Window Gallery

Row Number Spire

ROW_NUMBER window

Window+200 XP

Locked

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

Briefing

Windows number rows without collapsing them. Rank climbers by score — highest is rung 1.

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

ROW_NUMBER() OVER (ORDER BY score DESC), then ORDER BY rung.

Chamber schema

climbers3 cols

Climbers scored in the window gallery

idnamescore

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