you are at Encyclopedia of SQL >> AVG
AVG( `column_name` )
AVG() counts average worth of column given as a parameter.Syntax
SELECT AVG(`column_name`) FROM `table_name`
Example
Count average age of people from `people` table
name | surname | age |
---|---|---|
Paweł | Kowalski | 3 |
Piotr | Janik | 7 |
Michał | Nowak | 14 |
query
SELECT AVG(`age`) FROM `people`
result
AVG(`age`) |
---|
8 |