Chamber 23 · Tide Measure

Depth Marks

MIN and MAX together

GROUP BY+120 XP

Locked

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

Briefing

Same grouping habit, two aggregates. Report each trench's shallowest and deepest sounding.

Return trench_name, MIN(depth) as min_depth, MAX(depth) as max_depth, ordered by trench_name.

MIN and MAX share one GROUP BY trench_name.

Chamber schema

soundings4 cols

Depth soundings by trench

idtrench_namedepthcrew

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