Chamber 42 · Structure Vault

Round Tower

ROUND on grouped averages

ROUNDAVGGROUP BY+220 XP

Locked

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

Briefing

AVG and GROUP BY are familiar from brine measure. ROUND cleans each tier's mean to one decimal.

Return tier and ROUND(AVG(reading), 1) as avg_reading, ordered by tier.

ROUND(AVG(reading), 1) with GROUP BY tier.

Chamber schema

gauges3 cols

Structural readings by tower tier

idtierreading

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