Name 3 or more aggregate functions and the value they provide in your coding.

Answer 1

*    Average - Returns the average of the values in the select list ignoring the NULL values.
*    BINARY_CHECKSUM - The checksum as a binary value for a single row or for particular columns in a table.
*    CHECKSUM - The checksum as a integer value for a single row or for particular columns in a table.
*    CHECKSUM_AGG - Returns the checksum of the values in a table as an integer.
*    COUNT - Returns the number of items in the select list as an integer data type including NULL and duplicate values.
*    COUNT_BIG - Returns the number of items in the select list as a big integer data type including NULL and duplicate values.
*    DISTINCT - Not include duplicate values in the SELECT list.
*    GROUPING - The GROUPING aggregate is always used with a GROUP BY and either the ROLLUP or CUBE function to calculate the group's value.
*    MAX - The highest value in the SELECT list.
*    MIN - The lowest value in the SELECT list.
*    SUM - The sum of all the values in the SELECT list which are numeric data types ignoring the NULL values.
*    STDEV - The standard deviation for all of the values in the SELECT list.
*    STDEVP - The standard deviation for the population for all values in the SELECT list.
*    VAR - The variance of the population for all values in the SELECT list.
*    VARP - The variance of the population for all values in the SELECT list.