SQL AVG() Function
The SQL AVG() function is used to return an average number value from a selected column.
Example Customer Table
The following data table is for example only. Let's use AVG() function to get the average age from a customer table. The column we going to use are the Age columns.
| ID | Name | Age |
| 1 | Thomas Anderson | 45 |
| 2 | Andrew Golden | 38 |
| 3 | Ken Tom | 30 |
| 4 | Andrew Golden | 36 |
| 5 | Timothy Kirk | 32 |
| 6 | Kelly Smith | 39 |
Example of Running SQL Query
SELECT AVG(Age) AS Average_Age FROM Customers
After running the above query, it will return the following result.
| Average_Age |
| 36 |