The SQL AVG() Function

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

Return the average price of all products:


 SELECT  AVG(Price)

 FROM  products ;

You can click on above box to edit the code and run again.

Note: NULL values are ignored.

  SELECT AVG (column_name)

 FROM  table_name

 WHERE  condition;

You can click on above box to edit the code and run again.

Demo Products table

This product table is used for examples:

You can add a WHERE clause to specify conditions:

Return the average price of products in Product_id 2:   

 SELECT AVG(Price)

 FROM  products 

  WHERE  Product_id =  2 ;

You can click on above box to edit the code and run again.

It give the summarized column a name by using the AS keyword .

Name the column "average price": 


 SELECT AVG(Price) AS Average_price

 FROM  products ;

You can click on above box to edit the code and run again.

To list all records with a higher price than average, we can use the AVG()function in a sub query:

Return all products with a higher price than the average price: 


 SELECT * FROM  products

 WHERE price > (
 SELECT  AVG(Price)  FROM  Products);

You can click on above box to edit the code and run again.