595. Big Countries
来源:互联网 发布:淘宝店主软件 编辑:程序博客网 时间:2024/06/03 07:23
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 |+--------------+-------------+--------------+解题思路:运用SQL算法,提出name, population, area三列,再用where语句找出符合条件的项。MYSQL SELECT name, population, area FROM world WHERE population > 3000000 OR area > 25000000;
阅读全文
0 0
- 595. Big Countries
- [leetcode]595. Big Countries
- 595. Big Countries
- 595. Big Countries
- 【LeetCode】595. Big Countries
- 595. Big Countries
- 595. Big Countries
- 595. Big Countries
- [Leetcode]595.Big Countries
- 595. Big Countries
- [LeetCode] 595.Big Countries
- Big Countries
- LeetCode-595 Big Countries
- 2.leetCode595: Big Countries
- Big Countries [LeetCode 595]
- LeetCode——595. Big Countries(mysql)
- leetcode 595. Big Countries(SQL,最简单的leetcode题目)38
- Countries
- VL09增强-冲销
- 安卓学习笔记---Android Studio生成签名文件,自动签名,以及获取SHA1和MD5值
- 条形码的值来源一个函数[201511211707 (001-999以内的数字)]
- HTML5画布元素canvas提供的API使用方法
- Struts2 令牌
- 595. Big Countries
- java之对象数组
- 反素数
- #6175. 「美团 CodeM 初赛 Round B」黑白树
- HDU 4543|三足鼎立|曼哈顿距离|二分答案
- (Spring)springdata、spring、jpa、hibernate、springsecurity、maven整合
- 多线程C++(1)
- python 字典推导公式
- python函数