Last updated on August 3rd, 2024 at 11:01 pm
This Leetcode problem Big Countries LeetCode Solution is done in SQL.
List of all LeetCode Solution
Level of Question
Easy
Big Countries LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
name | varchar |
continent | varchar |
area | int |
population | int |
gdp | bigint |
World
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.
Return the result table in any order.
The result format is in the following example.
Example 1:
Input:
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 | population | area |
Afghanistan | 25500100 | 652230 |
Algeria | 37100000 | 2381741 |
1. Big Countries LeetCode Solution MySQL
select name, population, area from World where area >= 3000000 or population >= 25000000;
2. Big Countries LeetCode Solution Pandas
import pandas as pd def big_countries(world: pd.DataFrame) -> pd.DataFrame: df = world[(world['area'] >= 3000000) | (world['population'] >= 25000000)] return df[['name', 'population', 'area']]