595. Big Countries

https://leetcode.com/problems/big-countries/?

Pandas

import pandas as pd


def big_countries(world: pd.DataFrame) -> pd.DataFrame:
    return world[
        (world['area'] >= 3000000) | (world['population'] >= 25000000)
    ][['name', 'population', 'area']]

SQL

SELECT
    name,
    population,
    area
FROM World
WHERE area >= 3000000
OR population >= 25000000