Big Countries LeetCode Solution

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

Big Countries LeetCode Solution

Problem Statement

Column NameType
name varchar
continentvarchar
area int
populationint
gdp bigint
Table: 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:

namecontinent areapopulationgdp
AfghanistanAsia65223025500100 20343000000
AlbaniaEurope 28748283174112960000000
Algeria Africa 238174137100000188681000000
Andorra Europe 468 781153712000000
Angola Africa 1246700 20609294 100990000000
World table:

Output:

name populationarea
Afghanistan25500100652230
Algeria 371000002381741

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']]
Scroll to Top