Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

--What is the largest population size for Gabon in this dataset?
select country,population from population_years where country='Gabon'
order by population desc limit 1;


--What were the 10 lowest population countries in 2005?
SELECT country FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;

--What are all the distinct countries with a population of over 100 million in the year 2010?
select distinct country from population_years where year=2010
and population>100;

--How many countries in this dataset have the word “Islands” in their name?

select count(country) from population_years where country like '%Islands%';
--What is the difference in population between 2000 and 2010 in Indonesia?
select * from population_years where year between 2000 and 2010
and country='Indonesia';