Data Dungeon
← The Salt Crypts

Chamber 32 · Sovereign Shore

Section Boss

Salt Sovereign

Close the Salt Crypts

The Salt Sovereign waits beneath the foam. One wrong result set and the tide seals the shore.

BossEXISTSHAVINGGROUP BYINNER JOINORDER BY+200 XP
Locked

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 cols

Candidates for the Salt Sovereign

idnamerank
beacon_log3 cols

Proof of resurfacing

iddiver_idsurfaced_on
hauls4 cols

Gold hauled by each diver

iddiver_iditemgold
chamber_32.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.