SQLZOO练习-- SELECT from World（含题目翻译）

知识点

基础查询、常见运算符、like和%、round、length、left

 

数据表

world

 

题目内容

1.Read the notes about this table. Observe the result of running this SQL command to show the name, continent and population of all countries.（查询表中所有国家的名称、隶属洲、人口数量）

select name, continent, population from world

 

2.How to use WHERE to filter records. Show the name for the countries that have a population of at least 200 million. 200 million is 200000000, there are eight zeros.（查询人口数至少为200000000的国家）

select name from world
where population >= 200000000

 

3.Give the name and the per capita GDP for those countries with a population of at least 200 mil