本文介绍了一个SQL查询案例，目标是从一张包含世界各国信息的表格中筛选出面积大于3百万平方公里或人口超过25百万的大国，并展示如何使用简单的SQL语句实现这一需求。
#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, area
from World
where area > 3000000 or population > 25000000
for mysql
3.Answers
- same as my codes
- use union , and faster
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
