SQLZOO_5 SUM and COUNT_show the total population of the world. world(name

1.Show the total population of the world.
world(name, continent, area, population, gdp)

SELECT SUM(population)
FROM world
1
2

2.List all the continents - just once each.

select distinct continent from world
1

3.Give the total GDP of Africa

select sum(gdp) from world
where continent='Africa'
1
2

4.How many countries have an area of at least 1000000

select count(name) from world
where area>=1000000
1
2

5.What is the total population of (‘Estonia’, ‘Latvia’, ‘Lithuania’)

select sum(population) from world
where name in('Estonia','Latvia','Lithuania')
1
2

6.For each continent show the continent and number of countries.

select continent,count(name) from world
group by contine
1