SQL_ZOO_Solution/BBC_Quiz.sql at main · niyati-dot/SQL_ZOO_Solution · GitHub

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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
-- BBC Quiz :

SELECT
    name
FROM
    world
WHERE
    name LIKE 'U%';

-- 2) code which shows just the population of United Kingdom?
SELECT
    population
FROM
    world
WHERE
    name = 'United Kingdom';

--  3) shows the problem with this SQL code - the intended result should be the continent of France:
SELECT
    continent
FROM
    world
WHERE
    'name' = 'France';
-- Ans: 'name' should be name

SELECT
    name, population / 10
FROM
    world
WHERE
    population < 10000;
 -- Ans: Nauru	990

SELECT
    name, population
FROM
    world
WHERE
    continent IN ('Europe' , 'Asia');

-- 6)  code which would give two rows
SELECT
    name
FROM
    world
WHERE
    name IN ('Cuba' , 'Togo');

-- 7) result that would be obtained from this code:
SELECT
    name
FROM
    world
WHERE
    continent = 'South America'
        AND population > 40000000;
-- Ans:
-- Brazil
-- Colombia