Which branch wins when ranges overlap?

Question

Accepted Answer

CASE evaluates WHEN clauses top to bottom and stops at the first match. Order id=1: 50 < 100 -> 'Small'. Order id=2: 200 is not < 100, but 200 < 500 -> 'Medium'. Order id=3: 600 is neither < 100 nor < 500 -> ELSE 'Large'. Condition order matters - if you put amount < 500 before amount < 100, everything under 100 would match the first branch and never reach the second.