Chamber 32 · Sovereign Shore
Section BossSalt Sovereign
Close the Salt Crypts
The Salt Sovereign waits beneath the foam. One wrong result set and the tide seals the shore.
Clear the previous chamber to unlock this one. You can still preview the briefing.
Briefing
Final seal: resurfaced divers only (EXISTS), haul totals with HAVING, join + rank — every Lockward and brine habit at once.
Objective
Return diver name and SUM(gold) as total_gold for divers who EXISTS in beacon_log, HAVING SUM(gold) > 50, ordered by total_gold descending.
Hint
EXISTS beacon, GROUP BY diver, HAVING SUM(gold) > 50, ORDER BY total_gold DESC.
Chamber schema
divers3 colsCandidates for the Salt Sovereign
beacon_log3 colsProof of resurfacing
hauls4 colsGold hauled by each diver
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
I am the Warden. Ask for a hint, paste a failing query, or request a review — I won't hand you the full answer.