01_select_basics.sql

-- Spiderman Andew Garfield- NY accent

-- 1. Show the population of Germany
SELECT population
FROM world
WHERE name = 'Germany'

-- 2. Show the per capita gdp: (gdp/population) for each country where the area
-- is over 5,000,000 km^2
SELECT name country, gdp/population per_capita_gdp
FROM world
WHERE area > 5000000

-- 3. Show the name and continent where the area is less then 2000 and the gdp
-- is more than 5000000000
SELECT name country, continent
FROM world
WHERE area < 2000
AND gdp > 5000000000

-- 4. Show the name and the population for 'Denmark', 'Finland', 'Norway',
-- 'Sweden'
SELECT name country, population
FROM world
WHERE name IN ('Denmark', 'Finland', 'Norway', 'Sweden')

-- 5. Show each country that begins with G
SELECT name country
FROM world
WHERE name LIKE 'G%'

-- 6. Show the area in 1000 square km. Show area/1000 instead of area
SELECT name country, area/1000
FROM world
WHERE area BETWEEN 207600 AND 244820