网址:https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial
1、Introduction
Read the notes about this table. Observe the result of running this SQL command to show the name, continent and population of all countries.
观察运行此 SQL 命令的结果。
SELECT name, continent, population
FROM world
2、Large Countries
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.
使用 WHERE 来筛选记录。显示人口至少为 2 亿的国家名称。
SELECT name
FROM world
WHERE population > 200000000
3、Per capita GDP
Give the name
and the per capita GDP for those countries with a population
of at least 200 million.
对至少有2亿的国家计算人均国内生产总值。
SELECT name, gdp/population as 人均生产总值
FROM world
WHERE population > 200000000
4、South America In millions
Show the name
and population
in millions for the countries of the