MySQL AVG Function
Example Return the average value for the “Price” column in the “Products” table: SELECT AVG(Price) AS AveragePrice FROM Products; Definition and Usage The AVG() function returns the average value of an expression. Note: NULL values are ignored.