CASE expression v14
The CASE expression returns a value that's substituted where the CASE expression is located in an expression.
The two formats of the CASE expression are called a searched CASE and one that uses a selector.
selector_case_expression searched_case_expression