case
CASE is a conditional expression.
coalesce
Returns the first non-NULL expression among the input parameters.
if
If `expr1` evaluates to TRUE, returns `expr2`.
ifnull
If `expr1` is NULL, returns expr2.
nullif
Returns NULL if `expr1` is equal to `expr2`.