Chamber 64 · Loom Gallery

Double Weave

CASE in a second CTE

WITHCASE+420 XP

Locked

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

Briefing

First CTE filters strong threads — the second labels each row with CASE before the shuttle reads the weave.

Return name, tension, and grade from WITH strong AS (tension >= 50) and graded AS (CASE A/B on strong), selecting from graded.

Two CTEs: strong filters tension >= 50; graded adds CASE WHEN tension >= 60 THEN 'A' ELSE 'B'.

Chamber schema

threads4 cols

Gallery threads and tension

idnametensionwing

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