Chamber 67 · Tangled Archives

Archive Totals

CTE + GROUP BY

WITHINNER JOINGROUP BY+445 XP

Locked

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

Briefing

Roll every thread into a CTE, then sum tension per weaver — woven aggregates from a named step.

Return weaver name and total_tension from WITH roll AS (threads) joined and summed per weaver.

WITH roll AS (SELECT weaver_id, tension FROM threads), JOIN weavers, SUM tension GROUP BY name.

Chamber schema

weavers2 cols

Weavers in the archives

idname

threads3 cols

Archived thread tensions

idweaver_idtension

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