CASE_WHEN function

Returns one value if a logical expression (condition) is TRUE and another if it is FALSE.

Syntax

case_when(<condition>, <then>, <else>)

Parameter	Type	Description
condition	bool
then	any
else	any

Usages

case_when(`total_amount` > 100, "High", "Low")