Data Manipulation Functions / Using Aggregate Functions

SELECT
    Continent,
    AVG(Population)
FROM country
GROUP BY Continent


Continent AVG(Population)
Asia 72,647,562.74
Europe 15,871,186.95
North America 13,053,864.86
Africa 13,525,431.03
Oceania 1,085,755.35
Antarctica 0.00
South America 24,698,571.42

AVG() is used to return the average value of a specified column by counting both the number of rows in the table and the sum of their values.