Chamber 70 · Pattern Vault

Vault Derived

Subquery in FROM

SubqueryINNER JOINAVGGROUP BY+470 XP

Locked

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

Briefing

Average tension per weaver lives in a derived table — query the vault stats, then join names to the result.

Return weaver name and avg_tension from (SELECT weaver_id, AVG(tension) … GROUP BY) AS stats joined to weavers.

Derived table in FROM with AVG + GROUP BY, JOIN weavers, ORDER BY name.

Chamber schema

weavers2 cols

Weavers in the pattern vault

idname

threads3 cols

Vault thread readings

idweaver_idtension

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