Chamber 65 · Loom Gallery

Gallery Join

DISTINCT in a CTE

WITHDISTINCTINNER JOIN+430 XP

Locked

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

Briefing

DISTINCT in WITH strips duplicate spool IDs — only unique weavers who hold a hot thread qualify.

Return weaver name from WITH hot AS (SELECT DISTINCT weaver_id WHERE tension > 30) joined to weavers.

DISTINCT weaver_id in WITH, JOIN weavers ON id.

Chamber schema

weavers2 cols

Gallery weavers

idname

threads3 cols

Threads on the gallery spools

idweaver_idtension

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