AVG

SQL AVG Function

The AVG function returns the average of the values in a group. Null values are ignored.

SQL AVG syntax

SELECT AVG(column_name)
FROM table_name;

Training_Course

IDNAMEDURATIONPRICE
1SQL5200
2T-SQL7700
3MySQL5600
4PL/SQL7800
5PostgreSQL6500

Example

select AVG(PRICE) from Training_Course;

Results

560