Chamber 55 · Integrity Crypt

Tithe Null

COALESCE inside SUM

COALESCEGROUP BY+335 XP

Locked

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

Briefing

Some parishes sent no tithe — NULL, not zero. COALESCE before SUM so blanks count as 0 in the total.

Return parish and SUM(COALESCE(tithe, 0)) as total_tithe, grouped by parish, ordered by parish.

SUM(COALESCE(tithe, 0)) with GROUP BY parish.

Chamber schema

offerings3 cols

Tithes by parish (some missing)

idparishtithe

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