SELECT COUNT(*) FROM country;
SELECT COUNT(Code) FROM country;
SELECT COUNT(IndepYear) FROM country;
SELECT * FROM country WHERE IndepYear IS NULL;
SELECT COUNT(*) FROM country WHERE Population > 1000000000;
SELECT * FROM country ORDER BY Population DESC LIMIT 2;

SELECT MIN(Population) AS min_p, MAX(Population) AS max_p, AVG(Population) AS avg_p FROM country WHERE Population > 0;
SELECT MIN(`Name`), MAX(`Name`) FROM country;

SELECT SUM(Population) FROM country WHERE Population > 1000000000;
