Last updated on October 9th, 2024 at 10:33 pm

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

List of all LeetCode Solution

Big Countries 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:

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']]