What is the use of AVG() function in MySQL?

The AVG() function is used to return the average of the numeric column in a table.

AVG() Syntax

SELECT AVG(column_name) FROM table_name;

We have a table "employee" as below:

    employee
    id  first_name            last_name       salary
    .......................................................
    1   John                     Simp         10000
    2   Chris                    Hely         25000
    3   Joy                      Roy          20000
    4   Jenny                    Mill         35000

AVG() Example

The below query gives the average value of the "salary" column from the "employee" table:

SELECT AVG(salary) AS average_salary FROM employee; 

Hope this will help you :)