Chamber 41 · Window Gallery

Ranked Filter

Window plus subquery filter

WindowSubqueryORDER BY+215 XP

Locked

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

Briefing

Combine Spire windows with Lockward subqueries: rank only climbers above the tower average.

Return name, score, and RANK() OVER (ORDER BY score DESC) as place for climbers with score > (SELECT AVG(score) FROM climbers), ordered by place.

WHERE score > (SELECT AVG(score) FROM climbers), then window RANK.

Chamber schema

climbers3 cols

Climbers to filter then rank

idnamescore

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