Salary tier from a single threshold

Question

Accepted Answer

CASE WHEN evaluates each condition in order and returns the corresponding value for the first condition that is true. Alice's salary (90000) satisfies >= 70000, so she gets 'Senior'. Bob's salary (55000) does not, so the ELSE branch returns 'Junior'. CASE is an expression - it returns a value and can appear anywhere a value is expected: SELECT, WHERE, ORDER BY.