习题地址：

 

表结构：bbc(name, region, area, population, gdp)

 

2a.Show the name for the countries that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)

select name from bbc where population >= 200000000

 

2b.Give the name and the per capita GDP for those countries with a population of at least 200 million.

select name, GDP/populationfrom bbcwhere population >= 200000000

 

2c.Show the name and population in millions for the countries of 'Middle East'

Divide the population by 1000000 to get population in millions.

select name, population/1000000from bbcwhere region = 'Middle East'

 

2d.Show the name and population for 'France', 'Germany', 'Italy'

select name, populationfrom bbcwhere name in ('France', 'Germany', 'Italy')

 

2e.Identify the countries which have names including the word 'United'

select namefrom bbcwhere name like '%United%'