CASE when_clause [,...] [ ELSE scalar_expression_m ] END
WHEN search_condition_n THEN scalar_expression_n
- A scalar expression whose value is returned when no search_condition_n evaluates to TRUE.
- A predicate condition to be tested for truth.
- A scalar expression whose value is returned when search_condition_n is the first search condition that evaluates to TRUE.