UTCTODAY
The UTCTODAY function returns the current UTC (Coordinated Universal Time) date.
UTCNOW
The UTCNOW function returns the current UTC (Coordinated Universal Time) date and time.
DISTINCT (column)
The DISTINCT function that receives the name of a column as an input argument returns a table with a single column containing the unique values of the original column, that is, after eliminating duplicate values.
IN
The IN function returns a table that represents the subset of a column made up of those rows that contain a value that belongs to a given set.
If a scalar is specified instead of a column, the function returns True if the scalar in question appears in the table of values or in the specified set of values.
CONTAINS
The CONTAINS function allows you to evaluate whether there are rows with a certain value or values in one or more columns of a certain table. If positive, it returns True and, otherwise, it returns False.
NOT
The NOT function returns the logical value True if the argument it receives is False, and vice versa.
ABS
The ABS function returns the absolute value of a number.
RADIANS
The RADIANS function converts an angle in sexagesimal degrees to its equivalent in radians.
ASINH
The ASINH function returns the hyperbolic arcsine of a number.
ACOSH
The ACOSH function returns the hyperbolic arccosine of a number.
