Aggregation functions - MySQL

The AVG function in MySQL is used to calculate the average value of a numeric column. It sums up all the values in the column and divides the sum by the number of rows.

The SUM function in MySQL is used to calculate the sum of values in a numeric column. It adds up all the values present in the column and returns the total.

The COUNT function in MySQL is used to determine the number of rows in a result set or a specific column. It counts the number of records present in the specified context.

The MIN function in MySQL is used to retrieve the minimum value from a column. It compares all the values and returns the smallest value present in the specified column.

The MAX function in MySQL is used to retrieve the maximum value from a column. It compares all the values and returns the largest value present in the specified column.

The COUNT function in MySQL, when used with the DISTINCT keyword, returns the number of distinct values in a column. It counts only the unique values and disregards duplicates.

The COUNT function in MySQL, when used without any modifiers, returns the total number of non-null values in a column. It counts all the non-null records in the specified column.