AVG

Returns the average of a column in the resultset/group.

 

Example:

With the sample data set:

 

Field1

Field2

Field3

23

10

17

17

10

9

5

12

15

 

 

SELECT AVG(Field1) returns 15.