LeetCode 数据库面试题 – Big Countries

若一个国家的面积大于300万平方公里，或者人口大于2500万，则可以称之为大国。

请编写一条 SQL 返回所有大国的 name、population、area。

原题

There is a table World

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:

SQL

1SELECT 
2    name, population, area FROM World
3WHERE 
4    area > 3000000 OR population > 25000000