World Populations SQL Practice 1

gistfile1.txt

SELECT DISTINCT year from population_years;

SELECT *
FROM population_years
WHERE country IS "Gabon" 
ORDER BY population DESC
LIMIT 1;

SELECT *
FROM population_years
WHERE year IS "2005"
ORDER BY population ASC
LIMIT 10;

SELECT * 
FROM population_years
WHERE population > 100 AND year IS "2010";

SELECT DISTINCT country   
FROM population_years
WHERE country LIKE "%ISLANDS%";

SELECT * 
FROM population_years
WHERE country IS "Indonesia" AND (year = "2000" or year = "2010") ;