SQLZOO(SELECT from WORLD Tutorial)Writeup

1.

SELECT name, continent, population FROM world

2.

SELECT name FROM world
WHERE population>200000000

3.

select name,gdp/population from world 
where population >=200000000

4.

SELECT name, population/1000000 FROM world WHERE continent = 'South America'

5.

select name,population from world where name in ('France','Germany','Italy')

6.

SELECT name FROM world WHERE name LIKE '%United%'

7.

select name ,population ,area from world 
where area>3000000 or population > 250000000

8.

select name ,population ,area from world 
where (area>3000000 or population > 250000000)
AND name Not in ('United States','India','China')

9.

select name,round(population/1000000,2),round(gdp/1000000000,2) from world where continent='South America'

10

select name,round((gdp/population)/1000)*1000 from world where gdp >=1000000000000

11.

SELECT name,
       CASE WHEN continent='Oceania' THEN 'Australasia'
            ELSE continent END
  FROM world
 WHERE name LIKE 'N%'

12.

暂时没思路

13.

暂时没有思路