LeetCode 數據庫面試題 – Big Countries

若一個國家的面積大於300萬平方公里,或者人口大於2500萬,則可以稱之為大國。

請編寫一條 SQL 返回所有大國的 name、population、area。

原題

There is a table World

namecontinentareapopulationgdp
AfghanistanAsia6522302550010020343000
AlbaniaEurope28748283174112960000
AlgeriaAfrica238174137100000188681000
AndorraEurope468781153712000
AngolaAfrica124670020609294100990000

A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million.

Write a SQL solution to output big countries' name, population and area.

For example, according to the above table, we should output:

namepopulationarea
Afghanistan25500100652230
Algeria371000002381741

SQL

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