Overlapping WHEN conditions - order matters

Question

Accepted Answer

CASE evaluates WHEN clauses top to bottom and stops at the first match. Alice scores 95, which satisfies >= 70 - so she gets 'Pass', not 'Distinction', even though 95 >= 90 is also true. The second WHEN is never checked because the first already matched. To fix this, put the more specific condition (>= 90) before the broader one (>= 70). This is a common bug: both branches overlap, but the ordering makes the stricter check unreachable.