Large-Country Screening Report

Easy

You are given a table named World with one row per country. Columns: name: country name (unique) continent: continent label area: total area in square kilometers population: total population gdp: gross domestic product value A country must be included in the report if it satisfies at least one rule: area >= 3000000 population >= 25000000 Return exactly these columns: name population area The output row order is not important. Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

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 |

Output

[
  {"name":"Afghanistan","population":25500100,"area":652230},
  {"name":"Algeria","population":37100000,"area":2381741}
]

Explanation

Afghanistan and Algeria satisfy the population threshold. The other rows fail both rules.

Example 2

Input

World:
| name    | continent | area    | population | gdp |
|---------|-----------|---------|------------|-----|
| Atlasia | Test      | 3000000 | 1200000    | 500 |
| Borea   | Test      | 800000  | 25000000   | 700 |
| Cydra   | Test      | 2999999 | 24999999   | 900 |

Output

[
  {"name":"Atlasia","population":1200000,"area":3000000},
  {"name":"Borea","population":25000000,"area":800000}
]

Explanation

Threshold checks are inclusive, so exact values at 3000000 area or 25000000 population qualify.

Example 3

Input

World:
| name    | continent | area   | population | gdp |
|---------|-----------|--------|------------|-----|
| Delta   | Test      | 100000 | 9000000    | 100 |
| Epsilon | Test      | 200000 | 10000000   | 200 |

Output

[]

Explanation

No country reaches either threshold, so the output is empty.

Constraints

1 <= number of rows in World <= 10000
name is unique
1 <= area <= 1000000000
1 <= population <= 2000000000
0 <= gdp <= 100000000000000
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return exactly these columns: name, population, area

Preparing your editor. You can read the problem while it loads.

Large-Country Screening Report

Easy

You are given a table named World with one row per country. Columns: name: country name (unique) continent: continent label area: total area in square kilometers population: total population gdp: gross domestic product value A country must be included in the report if it satisfies at least one rule: area >= 3000000 population >= 25000000 Return exactly these columns: name population area The output row order is not important. Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

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 |

Output

[
  {"name":"Afghanistan","population":25500100,"area":652230},
  {"name":"Algeria","population":37100000,"area":2381741}
]

Explanation

Afghanistan and Algeria satisfy the population threshold. The other rows fail both rules.

Example 2

Input

World:
| name    | continent | area    | population | gdp |
|---------|-----------|---------|------------|-----|
| Atlasia | Test      | 3000000 | 1200000    | 500 |
| Borea   | Test      | 800000  | 25000000   | 700 |
| Cydra   | Test      | 2999999 | 24999999   | 900 |

Output

[
  {"name":"Atlasia","population":1200000,"area":3000000},
  {"name":"Borea","population":25000000,"area":800000}
]

Explanation

Threshold checks are inclusive, so exact values at 3000000 area or 25000000 population qualify.

Example 3

Input

World:
| name    | continent | area   | population | gdp |
|---------|-----------|--------|------------|-----|
| Delta   | Test      | 100000 | 9000000    | 100 |
| Epsilon | Test      | 200000 | 10000000   | 200 |

Output

[]

Explanation

No country reaches either threshold, so the output is empty.

Constraints

1 <= number of rows in World <= 10000
name is unique
1 <= area <= 1000000000
1 <= population <= 2000000000
0 <= gdp <= 100000000000000
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return exactly these columns: name, population, area