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 |
