0_select_basics.sql

-- Exercise reference: https://sqlzoo.net/wiki/SELECT_basics
-- Notes about table(make sure you included the last dot in the adress):
-- https://sqlzoo.net/wiki/Read_the_notes_about_this_table.
-- -----------------------------------------------------------------
--                           Table sample:
--
--                             world
-- | name        | continent | area    | population | gdp          |
-- | ----------- | --------- | ------- | ---------- | ------------ |
-- | Afghanistan | Asia      | 652230  | 25500100   | 20343000000  |
-- | Albania     | Europe    | 28748   | 2831741    | 12960000000  |
-- | Algeria     | Africa    | 2381741 | 37100000   | 188681000000 |
-- | Andorra     | Europe    | 468     | 78115      | 3712000000   |
-- | Angola      | Africa    | 1246700 | 20609294   | 100990000000 |
--                              ...
-- -----------------------------------------------------------------

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

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

-- Show the country and the area for countries
-- with an area between 200,000 and 250,000.
SELECT  name
       ,area
FROM world
WHERE area BETWEEN 200000 AND 250000;