Chamber 45 · Apex Seal

Apex Prelude

COALESCE, IN, OFFSET

COALESCEINOFFSETLIMITORDER BY+240 XP

Locked

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

Briefing

Warmup for the Archon: A/B ranks only, fill blank titles, skip the first name alphabetically.

Return name and COALESCE(title, 'Acolyte') as title where rank_code IN ('A', 'B'), ordered by name, LIMIT 3 OFFSET 1.

IN + COALESCE + ORDER BY name + LIMIT 3 OFFSET 1.

Chamber schema

aspirants4 cols

Candidates at the apex seal

idnametitlerank_code

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