stryke4711

-- how many entries in the table are from africa?

select continent, count(*) as 'no. of countries' from countries
WHERE continent = 'Africa';

-- what was the total population of the continent of oceania in 2005?

select continent, sum(population) as 'total population' from population_years
join countries
on countries.id = population_years.country_id