The AVG() Function
AVG()
returns the average value of a certain column.
Let's see an example:
SELECT AVG(population) FROM country;
AVG()
can also be used to find the average of a selected set of columns or rows that meet certain conditions. Hereβs an example:
SELECT AVG(population) FROM country WHERE population < 4478500;
Here is the country
table we are working with:
Task
Swipe to start coding
Write an SQL query to retrieve the average value of a surfacearea
column from the country
table.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 5. ChapterΒ 1