Codecademy export

population_queries.sqlite

/**SELECT COUNT(continent)
FROM countries
WHERE continent='Africa';

SELECT SUM(population)
FROM population_years
JOIN countries
ON countries.id=population_years.country_id
WHERE countries.continent='Oceania' AND year='2005';

SELECT MIN(population)
FROM population_years
JOIN countries 
ON countries.id=population_years.country_id
WHERE year='2007';

SELECT AVG(population)
FROM population_years
JOIN countries 
ON countries.id=population_years.country_id
WHERE name='Poland';

SELECT COUNT(*)
FROM countries
WHERE name LIKE '%The%';

SELECT *
FROM countries;

SELECT COUNT(name)
FROM countries
WHERE name LIKE '%_The_%';**/

SELECT *
FROM population_years
JOIN countries 
ON countries.id=population_years.country_id
WHERE year='2010'
GROUP BY continent
ORDER BY population DESC;