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