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