func.avg
This function returns the average of the values in a group. It ignores null values
This function returns the average of the values in a group. It ignores null values
An aggregate function that returns the number of rows, or the number of non-NULL rows
This function calculates the cumulative distribution of a value within a group of values
The DENSE_RANK() is a window function that assigns a rank to each row within a partition of a result set
FIRST_VALUE is an analytic function. It returns the first value in an ordered set of values
This analytic function lets you query more than one row in a table at a time without having to join the table to itself
The LAST_VALUE() function is a window function that returns the last value in an ordered partition of a result set
This analytic function provides access to more than one row of a table at the same time without a self join
The min() function returns the item with the lowest value, or the item with the lowest value in an iterable
This is a function that distributes rows of an ordered partition into a specified number of approximately equal groups, or buckets
The PERCENT_RANK() function evaluates the relative standing of a value within a partition of a result set
This is a function that assigns a rank to each row within a partition of a result set
This function is used to provide consecutive numbering of the rows in the result by the order selected in the OVER clause for each partition
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three