The MySql provides us with various for wide use for handling the database. The AVG() function is also one of the important function used in MySql. The AVG() is used to calculate the average value of the columns.
SELECT AVG(column-name) FROM table-name;
Now with the following statement we will be able to calculate the average price: