SELECT * FROM CITY;
SELECT SUM(Population) AS TOTAL_POPULATION FROM CITY;
SELECT * FROM COUNTRY;
SELECT MIN(LifeExpectancy) MIN_LIFE_EXPECTANCY FROM COUNTRY;
SELECT NAME, LifeExpectancy, ROUND(LifeExpectancy) AS NEW_LifeExpectancy FROM COUNTRY;
SELECT ROUND(Population/567.111,2) AS NEW_COLUMN FROM CITY;
SELECT *, POWER(ID, 2) AS NEW_COLUMN FROM CITY;