Data Dungeon
← The Lockward

Chamber 09 · Confiscation Vault

Unfilled Crypts

Tombs without occupants

LEFT JOIN+60 XP
Locked

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

Briefing

Beneath the vault, some crypts were carved and never filled. The archivist wants every tomb listed — even empty ones — alongside any prisoner buried there, if one exists.

Objective

Return all tomb names and buried prisoner names (including empty tombs), ordered by tomb id.

Hint

LEFT JOIN keeps every row from the left table even when there is no match.

Chamber schema

tombs3 cols

Every crypt in the catacombs

idnamewing
burials3 cols

Prisoners interred in tombs

tomb_idprisoner_nameburied_on
chamber_09.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.