美文网首页
[LeetCode]595. Big Countries

[LeetCode]595. Big Countries

作者: Eazow | 来源:发表于2017-07-27 14:58 被阅读35次
    题目

    There is a table World

    +-----------------+------------+------------+--------------+---------------+
    | name | continent | area | population | gdp |
    +-----------------+------------+------------+--------------+---------------+
    | Afghanistan | Asia | 652230 | 25500100 | 20343000 |
    | Albania | Europe | 28748 | 2831741 | 12960000 |
    | Algeria | Africa | 2381741 | 37100000 | 188681000 |
    | Andorra | Europe | 468 | 78115 | 3712000 |
    | Angola | Africa | 1246700 | 20609294 | 100990000 |
    +-----------------+------------+------------+--------------+---------------+

    > 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:
    

    +--------------+-------------+--------------+
    | name | population | area |
    +--------------+-------------+--------------+
    | Afghanistan | 25500100 | 652230 |
    | Algeria | 37100000 | 2381741 |
    +--------------+-------------+--------------+

    
    ##### 难度
    Easy
    
    ##### 方法
    没想到LeetCode有这么简单的题,直接写sql即可
    
    ##### SQL
    

    Write your MySQL query statement below

    select name, population, area from world where area > 3000000 or population > 25000000;

    相关文章

      网友评论

          本文标题:[LeetCode]595. Big Countries

          本文链接:https://www.haomeiwen.com/subject/nbmzkxtx.html