美文网首页leetcode
leetcode 595. Big Countries(mysq

leetcode 595. Big Countries(mysq

作者: syuhung | 来源:发表于2019-02-19 16:03 被阅读0次

    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

    题目大意:

      查找World表中area>3000000或者population>25000000的元组。

    解题思路:

      最基础的查询。

    解题代码:

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

    相关文章

      网友评论

        本文标题:leetcode 595. Big Countries(mysq

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