Clamp Percent Scores — Solution & ExplanationProblems / Clamp Percent Scores / EditorialApproach

Clamp with LEAST(GREATEST(x, lo), hi). GREATEST enforces the floor, LEAST the ceiling — the standard SQL spelling of clamp(x, 0, 100) (pandas: clip).

Flag from the raw value. raw_pct < 0 OR raw_pct > 100 states the rule directly; comparing raw <> clamped on floats invites representation surprises and hides the intent.

Key InsightGREATEST/LEAST are the horizontal min/max — across expressions within one row — while MIN/MAX are vertical, across rows. SQL splitting these into different function families trips up almost everyone once. The other habit this problem models: when cleaning data, *keep the evidence* — emitting was_clamped alongside the fix turns silent mutation into an auditable transformation, which is what separates cleaning from corrupting.Hints

Clamping is two operations composed: GREATEST(x, 0) raises anything below the floor, then LEAST(..., 100) lowers anything above the ceiling. The nesting order doesn't matter for a valid range.

GREATEST/LEAST are row-wise functions across their arguments — not aggregates like MAX/MIN, which collapse rows. Mixing those up is the classic first attempt.

The flag is a range check, not a comparison of raw vs clamped floats: raw_pct < 0 OR raw_pct > 100. Boundary values 0 and 100 must flag as 0.

Solve Clamp Percent Scores yourself →