Chamber 69 · Tangled Archives

Pattern Threshold

HAVING inside a CTE

WITHGROUP BYHAVING+465 XP

Locked

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

Briefing

HAVING filters grouped rows inside WITH — totals above threshold never leave the named weave.

Return weaver_id and total from WITH sums AS (GROUP BY weaver_id HAVING SUM(tension) > 100).

HAVING SUM(tension) > 100 inside the CTE after GROUP BY.

Chamber schema

threads3 cols

Threads for pattern totals

idweaver_idtension

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