LeetCode MySQL-595. Big Countries

    AllenLi
    LeetCode MySQL

    Write an SQL query to report the name, population, and area of the big countries.
    Return the result table in any order.

    寫一個 SQL Query來報告「name」、「population」、「area」，並回傳任意順序的結果。

    Table:

    +-------------+---------+
| Column Name | Type    |
+-------------+---------+
| name        | varchar |
| continent   | varchar |
| area        | int     |
| population  | int     |
| gdp         | int     |
+-------------+---------+
name is the primary key column for this table.
Each row of this table gives information about the name of a country, the continent to which it belongs, its area, the population, and its GDP value.

A country is big if:
it has an area of 'at least' three million (i.e., 3000000 km2), or
it has a population of 'at least' twenty-five million (i.e., 25000000).
(ex. 區域面積最少要 3000000 km2 or 人口最少要 25000000 人)

    Example 1:

    Input: 
World table:
+-------------+-----------+---------+------------+--------------+
| name        | continent | area    | population | gdp          |
+-------------+-----------+---------+------------+--------------+
| Afghanistan | Asia      | 652230  | 25500100   | 20343000000  |
| Albania     | Europe    | 28748   | 2831741    | 12960000000  |
| Algeria     | Africa    | 2381741 | 37100000   | 188681000000 |
| Andorra     | Europe    | 468     | 78115      | 3712000000   |
| Angola      | Africa    | 1246700 | 20609294   | 100990000000 |
+-------------+-----------+---------+------------+--------------+
Output: 
+-------------+------------+---------+
| name        | population | area    |
+-------------+------------+---------+
| Afghanistan | 25500100   | 652230  |
| Algeria     | 37100000   | 2381741 |
+-------------+------------+---------+

    Solution:
    1. 選擇標題「name」、「population」、「area」
    2. 來自於 World 的 table
    3. 設定條件「area >= 3000000」or「population >= 25000000」

    Code:

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

    LeetCode MySQL-595. Big Countries

    Related Posts