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