Chamber 22 · Tide Measure

Brine Average

AVG on a familiar GROUP BY

AVGGROUP BY+115 XP

Locked

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

Briefing

You grouped loot in the Lockward. Now average salinity per pool — AVG is the new piece.

Return pool_name and AVG(salinity) as avg_salinity, grouped by pool, ordered by pool_name.

GROUP BY pool_name with AVG — then ORDER BY pool_name.

Chamber schema

readings4 cols

Salinity samples by tide pool

idpool_namesalinitytaken_on

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