Sudhir-KNair

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- This is the first query:

SELECT DISTINCT year from population_years;

Sudhir-KNair

select count(*) FROM countries
where continent like '%africa%';

select continent,round(sum(population),2) as 'Total Population' from population_years
join
countries
on countries.id = population_years.country_id
where continent like '%Oceania%' AND year = 2005
group by continent;