Case Statement

The CASE expression evaluates conditions in order and returns a value when the first matching condition is met.

Syntax: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result END