select count(*) from countries;

slect avg(population) from countries;


select continent,avg(population) from countries group by continent;

select count(*) from countries where continent='africa' 
     and population between 2000000 and 6000000;