Data Dungeon
← Null Cathedral

Chamber 48 · Hollow Nave

Hollow Filter

NULL with AND

NULLWHERE+275 XP
Locked

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

Briefing

The nave clerk wants active acolytes who never swore a vow — two predicates, one WHERE.

Objective

Return name and status where vow IS NULL AND active = 1, ordered by name.

Hint

AND vow IS NULL with active = 1, then ORDER BY name.

Chamber schema

acolytes5 cols

Acolytes with optional vows

idnamevowstatusactive
chamber_48.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.