Large-Country Screening Report

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

world =

[{"name":"Afghanistan","continent":"Asia","area":652230,"population":25500100,"gdp":20343000000},{"name":"Albania","continent":"Europe","area":28748,"population":2831741,"gdp":12960000000},{"name":"Algeria","continent":"Africa","area":2381741,"population":37100000,"gdp":188681000000},{"name":"Andorra","continent":"Europe","area":468,"population":78115,"gdp":3712000000},{"name":"Angola","continent":"Africa","area":1246700,"population":20609294,"gdp":100990000000}]

Large-Country Screening Report

Hints

Large-Country Screening Report

Hints