LeetCode/Ritコード-大国家-MySQL


質問する



に答える

  • 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, popluation and area.
  • for example, according to the above table, we should output
  • 検索

    -- leetcode, Big Countries, mysql
    SELECT name, population, area
    FROM World
    WHERE area >= 3000000 OR population >= 25000000

    結果




    ソース&ハーブ


    leetcode
    github