PL/SQL Avg

The Avg function returns the average value of an table column or expression.

Avg syntax

select avg(expression) from table;

Avg example

COURSE_ID	NAME	DESCRIPTION	DURATION	PRICE
1	SQL 1	SQL course for beginners	1 week	10
2	SQL 2	SQL course for advanced	2 week	50
3	HTML5	Learn HTML 5	1 week	10
4	PHP	PHP course	4 week	75
5	CSS	Learn CSS	2 week	20

select avg(price) from course;

Result: 33


select avg(price*2) from course;

Result: 66


select avg(price) from course where price between 20 and 50;

Result: 35

↑