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

ID NAME DURATION PRICE
1 SQL 5 200
2 T-SQL 7 700
3 MySQL 5 600
4 PL/SQL 7 800
5 PostgreSQL 6 500

Example

select AVG(PRICE) from Training_Course;

Results

560