-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathBig countries
More file actions
20 lines (17 loc) · 793 Bytes
/
Big countries
File metadata and controls
20 lines (17 loc) · 793 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| name | varchar |
| continent | varchar |
| area | int |
| population | int |
| gdp | bigint |
+-------------+---------+
name is the primary key (column with unique values) for this table.
Each row of this table gives information about the name of a country, the continent to which it belongs, its area, the population, and its GDP value.
A country is big if:
it has an area of at least three million (i.e., 3000000 km2), or
it has a population of at least twenty-five million (i.e., 25000000).
Write a solution to find the name, population, and area of the big countries.
SOLUTION:
select name, population, area from World where (area >= 3000000) or (population >=25000000);