Index Archon

Close the Index Spire

The Index Archon waits at the apex. One wrong result set and the tower indexes collapse.

BossWindowINNER JOINSubqueryORDER BY+260 XP

Locked

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

Briefing

Final seal: unsealed floors only, scores above the tower average, RANK() over the survivors — window, join, and subquery as one.

Objective

Return climber name, floor name as floor_name, score, and RANK() OVER (ORDER BY score DESC) as place for climbers on floors where sealed = 0 and score > (SELECT AVG(score) FROM climbers), ordered by place.

Hint

Join floors, filter sealed = 0 and score > AVG subquery, RANK(), ORDER BY place.

Chamber schema

climbers4 cols

Apex climbers and scores

idnamescorefloor_id

floors3 cols

Spire floors and seal state

idnamesealed

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