SELECT sum(population)
FROM world
select distinct continent from world
SELECT sum(gdp)
FROM world
where continent='Africa'
select count(name) from world where area>=1000000
SELECT sum(population)
FROM world where name in ('France','Germany','Spain')
select continent,count(name) from world group by continent
select continent,count(name) from world where population>=10000000 group by continent
select continent from world group by continent having sum(population)>=100000000