SQL AVG

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]

EXAMPLE :

Let's try it out with a simple example which is return average of the scores in the table.

Table GameScores

SQL statement :

SELECT AVG(Scores) FROM GameScores

Result: