The **`AVG()` function** returns the average value of a set of values. 

Figure 1 shows a visual representation of the `AVG()` function.

# Syntax
```sql
AVG(column)
```
# Parameter
The `AVG()` function takes a column or field as a parameter. 

# Return value
The `AVG()` function returns the average value of a #key# set of values: column name #key# sent as a parameter.  

> This function ignores the `NULL` values in the column or field.

# Code
The following example shows how we can get the average of the student marks using the `AVG()` function.




Students

select AVG(studentMarks) as averageStudentMarks
from Students

What is AVG() in SQL?

The AVG() function in SQL calculates the average value of a set of values in a specified column, ignoring NULLs.

*Student ID*	*Student Name*	*Student Marks*
1	David	22
2	Luiss	20
3	Harvey	15
4	Lucy	25
5	Andrew	10