# AVG function in MySQL

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 utilised 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’.