# Big Countries LeetCode Solution

This Leetcode problem Big Countries LeetCode Solution is done in SQL.

# List of all LeetCode Solution

## Problem Statement

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:

Output:

## Big Countries LeetCode Solution MySQL

``````select
name,
population,
area
from
World
where
area >= 3000000
or population >= 25000000;```Code language: SQL (Structured Query Language) (sql)```

## 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']]```Code language: SQL (Structured Query Language) (sql)```
Scroll to Top