LeetCode刷题#595
来源:互联网 发布:四年级英语辅导软件 编辑:程序博客网 时间:2024/06/02 00:56
#595 Big Countries
1. Problem Description
There is a table World
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:
2. My Codes
select name, population, areafrom Worldwhere area > 3000000 or population > 25000000
for mysql
3.Answers
- same as my codes
- use union , and faster
阅读全文
0 0
- LeetCode刷题#595
- 【LeetCode】Leetcode刷题 笔记
- 17.9.15leetcode刷题(595)
- leetcode 刷题
- LeetCode刷题
- LeetCode刷题
- Leetcode刷题
- leetcode刷题
- Leetcode刷题
- leetcode刷题
- 【leetcode】leetcode 刷题 笔记 (不定期更新)
- SQL-LeetCode-easy-595
- LeetCode-595 Big Countries
- LeetCode:595 Big Countions
- Big Countries [LeetCode 595]
- leetcode刷题 开始篇
- leetcode 刷题:LRU cache
- leetcode刷题:atoi
- python初学1
- 猜数字游戏
- 【HAOI2015】树上操作(树链剖分)
- Codeforces 845B Luba And The Ticket (贪心)
- Java反射学习
- LeetCode刷题#595
- RTSP解析
- Quartz应用与集群原理分析
- HDU 3584 Cube(三位树状数组)
- 关于Home Lab的搭建——硬件选择篇(迷你主机)(一)
- JS能力测评经典题
- python简单爬虫练习
- java鬼混笔记:Hibernate:7、乐观锁(有代码)和悲观锁(无代码)
- yum 安装报错 error: 404 Error: Cannot retrieve repository metadata 解决方法