PostgreSQL AVG Function
AVG
The AVG()
function returns the average value of a numeric column.
Example
Return the average price of all the products in the products table:
SELECT AVG(price)
FROM products;
Run Example »
Note: NULL values are ignored.
With 2 Decimals
The above example returned the average price of all products, the result was
28.8663636363636364.
We can use the ::NUMERIC operator to round the average price to a number with 2 decimals:
Example
Return the average price of all the products, rounded to 2 decimals:
SELECT AVG(price)::NUMERIC(10,2)
FROM products;
Run Example »
Exercise?What is this?
Test your skills by answering a few questions about the topics of this page
Drag and drop the missing code to select the average value of all 'year' columns.
FROM cars;COUNT(year)AVERAGEyearAVG(year)MID(year)MODEyear)MEAN(year)SELECTPRINT
