Data Dungeon
← The Fractured Loom

Chamber 61 · Warp Hall

Warp Thread

WITH names a step

WITHWHERE+395 XP
Locked

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

Briefing

The loom clerk names each weave step before the main query runs — a WITH clause is the warp you thread first.

Objective

Return name and skill from active weavers (active = 1) using WITH active AS (...).

Hint

WITH active AS (SELECT name, skill FROM weavers WHERE active = 1), then SELECT from active.

Chamber schema

weavers4 cols

Loom weavers and their craft

idnameskillactive
chamber_61.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.