%%capture
%load_ext sql
%sql sqlite:///factbook.db
%%sql
SELECT *
FROM facts
LIMIT 5;
Done.
%%sql
SELECT MIN(population) as min_population
FROM facts;
Done.
%%sql
SELECT MAX(population) as max_population
FROM facts;
Done.
%%sql
SELECT MIN(population_growth) as min_population_growth
FROM facts;
Done.
%%sql
SELECT MAX(population_growth) as max_population_growth
FROM facts;
Done.
%%sql
SELECT name
FROM facts
WHERE population = (SELECT MIN(population) FROM facts);
Done.
%%sql
SELECT name
FROM facts
WHERE population = (SELECT MAX(population) FROM facts);
Done.
%%sql
SELECT AVG(population)
FROM facts
WHERE name != "World";
Done.
%%sql
SELECT AVG(area)
FROM facts
WHERE name != "World";
Done.
%%sql
SELECT name
FROM facts
WHERE name != "World"
and population > (SELECT AVG(population) FROM facts WHERE name != "World")
and ar > (SELECT AVG(population) FROM facts WHERE name != "World")
Done.