Grouping and Summarization

Summarization functions like stdev, max, and median

func.first

This function returns the value of a specified field in the first record of the result set returned by a query

func.last

This function returns the value of a specified field in the last record of the result set returned by a query

func.max

The MAX function is an aggregate function that returns the maximum value in a set of values

func.median

This function will calculate the middle value of a given set of numbers

func.stdev

The STDEV function calculates the standard deviation for a sample set of data

func.stdev_pop

STDDEV_POP computes the population standard deviation and returns the square root of the population variance

func.stdev_samp

STDDEV_SAMP() function returns the sample standard deviation of an expression

func.var_pop

VAR_POP returns the population variance of a set of numbers after discarding the nulls in this set

func.var_samp

VAR_SAMP returns the sample variance of a set of numbers after discarding the nulls in this set

func.variance

This function is used to determine how far a set of values is spread out based on a sample of the population

Last modified November 27, 2023 at 12:56 PM EST: Restructured the file structure/a few changes (f6c58b8)