MrN00b0t

SELECT COUNT(*) AS 'No. Of Countries Sampled in Africa'
FROM countries 
WHERE continent = 'Africa';
SELECT ROUND(SUM(population), 2) AS 'Population of Oceania in 2005 (mil)'
FROM countries
JOIN population_years
ON countries.id = population_years.country_id
WHERE countries.continent = 'Oceania' AND population_years.year = 2005;
SELECT ROUND(AVG(population), 2) AS 'Average Population of South American Country in 2003 (mil)'
FROM countries