AVG function in MySQL

by

MySQL AVG
In MySQL, the AVG function is used to get the average value of an expression.

Syntax:

SELECT AVG (aggregate_expression)  
FROM table_name  
WHERE conditions;

Parameters:

Aggregate_expression: It is used to specify the column or expression to be utilized by the AVG function.

Example: Items table:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion 100
4 Grocery 90
5 Toys 50

 

Query:

SELECT AVG(quantity) AS “Average Quantity”
FROM items;

Output:

AVERAGE QUANTITY
63

Explanation:

The ‘items’ is an already existing table from which we are calculating the average value of ‘quantity’.