AND function
Returns TRUE if all of the provided arguments are logically TRUE, and FALSE if any of the provided arguments are logically FALSE.
Returns TRUE if all of the provided arguments are logically TRUE, and FALSE if any of the provided arguments are logically FALSE.
Returns one value if a logical expression (condition) is TRUE and another if it is FALSE.
Checks whether the referenced column or expression is empty or NULL.
Checks whether the referenced column or expression is NULL.
Returns the opposite of a logical value - not(TRUE) returns FALSE; not(FALSE) returns TRUE.
Returns TRUE if any of the provided arguments are logically TRUE, and FALSE if all of the provided arguments are logically FALSE.