Chamber 16 · Gate of Seals
Twin Ledgers
Merge two rolls
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 colsPrisoners logged on day shift
night_roll2 colsPrisoners logged on night shift
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
I am the Warden. Ask for a hint, paste a failing query, or request a review — I won't hand you the full answer.