Loom Weaver

Close the Fractured Loom

The Lockward seal waits. Five floors of queries stand behind you — one wrong result set and the gate stays shut.

BossWITHWindowEXISTSINNER JOINGROUP BYORDER BY+520 XP

Locked

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

Briefing

Final weave: active weavers who logged a shift, totals in WITH, rank by woven tension — every prior thread pulled tight.

Objective

Return weaver name, total, and RANK() OVER (ORDER BY total DESC) as standing for active weavers with EXISTS in shifts and totals from WITH, ordered by standing.

Hint

WITH totals, JOIN weavers + totals, EXISTS shifts, active = 1, RANK() on total, ORDER BY standing.

Chamber schema

weavers3 cols

Active weavers at the seal

idnameactive

threads3 cols

Thread tensions per weaver

idweaver_idtension

shifts3 cols

Logged loom shifts

idweaver_idshift_on

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