[MySQL][LeetCode][Easy] 595. Big Countries

心得:

這題只要找出領土大於三百萬或是人口大於兩百五十萬的的資料即可

問題:

There is a table World

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

+-----------------+------------+------------+--------------+---------------+
>
> | name | continent | area | population | gdp |
>
> +-----------------+------------+------------+--------------+---------------+
>
> | Afghanistan | Asia | 652230 | 25500100 | 20343000 |
>
> | Albania | Europe | 28748 | 2831741 | 12960000 |
>
> | Algeria | Africa | 2381741 | 37100000 | 188681000 |
>
> | Andorra | Europe | 468 | 78115 | 3712000 |
>
> | Angola | Africa | 1246700 | 20609294 | 100990000 |
>
> +-----------------+------------+------------+--------------+---------------+
>
>

A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million.

Write a SQL solution to output big countries’ name, population and area.

For example, according to the above table, we should output:

1
2
3
4
5
6
7
8
9
10
11
12
13
14

+--------------+-------------+--------------+
>
> | name | population | area |
>
> +--------------+-------------+--------------+
>
> | Afghanistan | 25500100 | 652230 |
>
> | Algeria | 37100000 | 2381741 |
>
> +--------------+-------------+--------------+
>
>

答案:

1
2
3
4
5
6
7
8
9
10
11
12

# Write your MySQL query statement below
SELECT
name,
population,
area
FROM
World
WHERE
area > 3000000
OR
population > 25000000