--02. Large Countries

SELECT name FROM world

WHERE population >= 200000000;

--03. Per capita GDP

SELECT name, gdp / population AS perCapitaGDP

FROM world

WHERE population >=200000000;

--04. South America In millions

SELECT name, population / 1000000

FROM world

WHERE continent = 'South America';

--05. France, Germany, Italy

SELECT name, population

FROM world

WHERE name IN ('France', 'Germany', 'Italy');

--06. United

SELECT name FROM world

WHERE name LIKE 'United%';

--07. Two ways to be big

SELECT name,population,area FROM world

WHERE area >=3000000 OR population >=250000000;

--08.One or the other (but not both)

SELECT name,population,area

FROM world

WHERE area >=3000000 XOR population >= 250000000;

--09. Rounding

SELECT name,ROUND(population/1000000,2),ROUND(gdp/1000000000,2)

FROM world

WHERE continent = 'South America';

--10. Trillion dollar economies

SELECT name,ROUND(gdp/population,-3) AS perCapitaGDP

FROM world

WHERE gdp >=1000000000000;

--11.Name and capital have the same length

SELECT name,capital

FROM world

WHERE length(name) = length(capital)

ORDER BY name;

--12. Matching name and capital

SELECT name,capital

FROM world

WHERE LEFT(name,1) = LEFT(capital,1) AND name <> capital;

--13. All the vowels

SELECT name

FROM world

WHERE name LIKE '%a%' AND name LIKE '%e%'AND name LIKE '%i%' AND name LIKE '%o%' AND name LIKE '%u%'

AND name NOT LIKE '% %';