Chamber 38 · Catalog Wing

Coalesce Cast

Both null-fill and cast

COALESCECAST+195 XP

Locked

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

Briefing

Some spans lack a recorded height. Treat missing text as '0', cast to integer, and list the tallest first.

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

COALESCE inside CAST, then ORDER BY height DESC.

Chamber schema

spans3 cols

Spans with optional height text

idlabelheight_text

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