MySql Aggregate Functions

MySql Aggregate Functions allow us to calculate a summary of values from a column and from groups of values within a column.
The following are the aggregate functions,

• AVG() - Returns the average of the non-NULL values in the specified field.
• SUM() - Returns the sum of the non-NULL values in the specified field.
• MIN() - Returns the minimum of the non-NULL values in the specified field.
• MAX() - Returns the maximum of the non-NULL values in the specified field.
• COUNT() - Returns the number of rows containing non-NULL values in the specified field.