Chamber 43 · Structure Vault

Cross Index

JOIN with IN

INNER JOININ+225 XP

Locked

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

Briefing

Join tomes to shelves, but only wings in ('North', 'East') — JOIN and IN together.

Return tome title and shelf label for shelves.wing IN ('North', 'East'), ordered by title.

INNER JOIN shelves, WHERE wing IN ('North', 'East'), ORDER BY title.

Chamber schema

tomes3 cols

Indexed tomes

idtitleshelf_id

shelves3 cols

Shelves by wing

idlabelwing

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