Chamber 21 · Brine Gallery
Brine And
Stack LIKE with BETWEEN
LIKEBETWEENWHEREORDER BY+110 XP
Locked
Clear the previous chamber to unlock this one. You can still preview the briefing.
Briefing
The gallery's gate wants both: a Salt name and a mid-tide mark. Combine the two new tools with AND.
Objective
Return name and tide_mark from relics where name LIKE '%Salt%' AND tide_mark BETWEEN 3 AND 7, ordered by name.
Hint
AND both predicates, then ORDER BY name.
Chamber schema
relics4 colsRelics with names and tide marks
idnametide_markvalue
chamber_21.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.