Chamber 72 · Pattern Vault

Fracture Standing

Window on a CTE

WITHWindowORDER BY+490 XP

Locked

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

Briefing

East-wing threads named in WITH, then ROW_NUMBER ranks the fracture — window functions on a woven step.

Return name and standing from WITH east AS (wing = 'East') with ROW_NUMBER() OVER (ORDER BY tension DESC), ordered by standing.

WITH east AS (WHERE wing = 'East'), ROW_NUMBER OVER tension DESC, ORDER BY standing.

Chamber schema

threads4 cols

East-wing threads for ranking

idnametensionwing

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