Data Dungeon
← The Lockward

Chamber 16 · Gate of Seals

Twin Ledgers

Merge two rolls

UNION+85 XP
Locked

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

Briefing

Day shift and night shift keep separate rolls. The gate will not open until both lists are stacked into one ordered column of names.

Objective

Return a single name column that unions day_roll and night_roll names, ordered alphabetically.

Hint

UNION stacks two SELECTs with the same column shape and drops duplicates.

Chamber schema

day_roll2 cols

Prisoners logged on day shift

idname
night_roll2 cols

Prisoners logged on night shift

idname
chamber_16.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.