The SQL AVG aggregate function is used to calculate the average values of the column.
The SQL AVG syntax is simple and looks like this:
SELECT AVG ( [COLUMN NAME] ) FROM [TABLE NAME]
Let's try it out with a simple example which is return average of the scores in the table.
SQL statement :
SELECT AVG(Scores) FROM GameScores