Case When Labels — Solution & ExplanationProblems / Case When Labels / EditorialApproachCASE WHEN is SQL's if/else — it evaluates conditions top-down and returns the first match.

Check score >= 90 first (grade A).

Then >= 80 (B), >= 70 (C), >= 60 (D).

ELSE 'F' catches everything below 60.

The order of WHEN clauses matters. If you checked >= 60 first, every score above 60 would get a D.Hints

CASE WHEN checks conditions in order and returns the first match.

Always include an ELSE clause for the default case.

Order matters — put the highest threshold first since CASE stops at the first true condition.

Solve Case When Labels yourself →