Chamber 24 · Tide Measure

Salt Having

Filter groups after AVG

AVGHAVINGGROUP BY+130 XP

Locked

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

Briefing

HAVING returns from the Lockward tithe. Keep only pools whose average salinity exceeds 20.

Return pool_name and AVG(salinity) as avg_salinity for pools with AVG(salinity) > 20, ordered by pool_name.

HAVING AVG(salinity) > 20 after GROUP BY — not WHERE.

Chamber schema

readings3 cols

Salinity samples by tide pool

idpool_namesalinity

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