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