ποΈ 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`.
