SQL AVG() Function

The AVG() Function

The AVG() function returns the average value of a numeric column.

SELECT AVG(column_name) FROM table_name

We have the following "Purchases" table:

PU_ID	OrderDate	OrderPrice	Customer
1	2015/11/12	1000	Karmen
2	2015/10/23	1600	Tendulkar
3	2015/09/02	700	Karmen
4	2015/09/03	300	Karmen
5	2015/08/30	2000	Jensen
6	2015/10/04	100	Tendulkar

Now we want to find the average value of the "OrderPrice" fields.

We use the following SQL statement:

SELECT AVG(OrderPrice) AS OrderAverage FROM Purchases

The result-set will look like this:

OrderAverage
950

Now we want to find the customers that have an OrderPrice value higher than the average OrderPrice value.

We use the following SQL statement:

SELECT Customer FROM Purchases
WHERE OrderPrice>(SELECT AVG(OrderPrice) FROM Purchases)

The result-set will look like this: