MySQL AVG & SUM: Calculate Statistics

In MySQL, aggregate functions can be used to calculate statistical information such as averages and sums of query results. Here are some commonly used aggregate functions:

1. Calculate the average of a column.

SELECT AVG(column_name) FROM table_name;

1. SUM: Calculate the total sum of a column.

SELECT SUM(column_name) FROM table_name;

1. COUNT: calculate the number of rows in a column

SELECT COUNT(column_name) FROM table_name;

1. MAX: Calculate the maximum value of a column.

SELECT MAX(column_name) FROM table_name;

1. MIN: Calculate the minimum value of a column.

SELECT MIN(column_name) FROM table_name;

It is important to note that when using aggregate functions, it is usually necessary to include a GROUP BY clause in the SELECT statement to specify which columns to group the calculations by. Additionally, the results can also be filtered using the HAVING clause.