Part time Business Intelligence Analyst. Full time Data Science Student.

SQL Aggregate Functions

The main aggregate functions in MySQL consist of:

  • [[The COUNT() function]] - counts the number of non-null records in a field
  • [[The AVG() function ]] - calculates the average of all non-null values belonging to a certain column of a table
  • [[The SUM() function]] - sums all the non-null values in a column
  • [[The MIN() function]] - returns the minimum value from the entire list
  • [[The MAX() function]] - returns the maximum value from the entire list
  • [[The ROUND() function]] - Rounds a number to a specified number of decimal places
  • [[The COALESCE function]] - Returns the first non-null value in a list
  • [[The IFNULL() function]] - Returns a specified value if the expression is NULL.