This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries.
name | continent | area | population | gdp |
---|---|---|---|---|
Afghanistan | Asia | 652230 | 25500100 | 20343000000 |
Albania | Europe | 28748 | 2831741 | 12960000000 |
Algeria | Africa | 2381741 | 37100000 | 188681000000 |
Andorra | Europe | 468 | 78115 | 3712000000 |
Angola | Africa | 1246700 | 20609294 | 100990000000 |
... |
1、
List each country name where the population is larger than that of 'Russia'.
world(name, continent, area, population, gdp)
2、
Show the countries in Europe with a per capita GDP greater than 'United Kingdom'.
3、 List the name and continent of countries in the continents containing either Argentina or Australia . Order by name of the country.
4、 Which country has a population that is more than Canada but less than Poland? Show the name and the population.
5、
Germany (population 80 million) has the largest population of the countries in Europe. Austria (population 8.5 million) has 11% of the population of Germany.
Show the name and the population of each country in Europe. Show the population as a percentage of the population of Germany.
Decimal places
Percent symbol %
7、 Find the largest country (by area) in each continent, show the continent , the name and the area :
8、 List each continent and the name of the country that comes first alphabetically.
9、Find the continents where all countries have a population <= 25000000. Then find the names of the countries associated with these continents. Show name, continent and population.
10、Some countries have populations more than three times that of any of their neighbours (in the same continent). Give the countries and continents.
原文链接 http://blog.csdn.net/crazy__chen/article/details/50503773