MYSQL functions AVG COUNT SUM MIN MAX

For these functions, we will take this given table as an example.

AVG()

Find the average product price.

SELECT AVG(price) AS average_price FROM products;

COUNT()

Count all the records 

SELECT COUNT(product_name) AS total_products FROM products;

SUM()

Calculate the sum of the specified field value.

SELECT SUM(price) AS total_price FROM products;

MIN()

Find the smallest value of the specified field.

SELECT MIN(price) AS minimum_price FROM products;

MAX()

Find the greatest value in the specified field.

SELECT MAX(price) AS maximum_price FROM products;