select in select
部分的小测quiz
,5
个不同的字段信息
习题
- Select the code that shows the name, region and population of the smallest country in each region
每个地区人口最少的国家
1 | select region, name, population |
相当于是把同一个地区中的人数进行对比,选择最少的那个
- Select the code that shows the countries belonging to regions with all populations over 50000
地区中每个国家的人数都超过了50000的地区region
1 | select name, region, population |
- Select the code that shows the countries with a less than a third of the population of the countries around it
同一个地区中某个国家的人口小于其他国家的3分之一
1 | select name, region |
- 根据代码选择答案
人口比英国多
和英国在同一个地区
1 | select name from bbc |
- Select the code that would show the countries with a greater GDP than any country in Africa (some countries may have NULL gdp values).
比非洲所有的国家的gdp都要大;考虑有些国家没有gdp
1 | select name from bbc |
- Select the code that shows the countries with population smaller than Russia but bigger than Denmark
人口比俄罗斯小,比Denmark大
1 | select name from bbc |
- 根据代码选答案
- 比欧洲所以国家的人口都要多
- 地区在南亚
1 | select name from bbc |