-
Notifications
You must be signed in to change notification settings - Fork 0
/
01_select_basics.sql
35 lines (29 loc) · 941 Bytes
/
01_select_basics.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
-- 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