Chamber 37 · Catalog Wing

Cast Height

Text to number

CAST+185 XP

Locked

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

Briefing

Heights were stored as text. CAST them so ORDER BY ranks the tallest first — sorting you already trust.

Return label and CAST(height_text AS INTEGER) as height, ordered by height descending.

CAST(… AS INTEGER) then ORDER BY height DESC.

Chamber schema

steps3 cols

Step labels with height stored as text

idlabelheight_text

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