SQL学习-sqlzoo练习题记录(3)

4-子查询
注意：子查询有所会得出多于一个的结果，如果进行结果比较会出现错误，此时使用IN会更加安全。

原网站教学：
1)

SELECT name FROM world WHERE continent = 
(SELECT continent 
FROM world WHERE name = 'Brazil')

2)

SELECT name, continent FROM world
WHERE continent IN
  (SELECT continent 
     FROM world WHERE name='Brazil'
                   OR name='Mexico')

3)

SELECT
 population/(SELECT population FROM world
             WHERE name='United Kingdom')
  FROM world
WHERE name = 'China'

4)

SELECT name FROM world
 WHERE population > ALL
      (SELECT population FROM world
        WHERE continent='Europe')

注意点：可以使用 ALL 或 ANY ，当运算符后有多于一个值后

练习：
1)

SELECT name FROM world
WHERE population >
     (SELECT population FROM world
      WHERE name='Russia')

2)

SELECT name FROM world
WHERE continent='Europe' 
AND gdp/population >
    (SELECT gdp/population FROM world WHERE name=