SELECT Quiz/zh

From SQLZOO
Jump to: navigation, search
Language: English  • 中文

一些關於基本SQL語句的問題

name region area population gdp
Afghanistan South Asia 652225 26000000
Albania Europe 28728 3200000 6656000000
Algeria Middle East 2400000 32900000 75012000000
Andorra Europe 468 64000
...
選擇產生此表的代碼。
namepopulation
Bahrain1234571
Swaziland1220000
Timor-Leste1066409
FROM world
SELECT name, population BETWEEN 1000000 AND 1250000
FROM name, population 
WHERE population BETWEEN 1000000 AND 1250000
SELECT world
SELECT name, population
  FROM world
 WHERE population BETWEEN 1000000 AND 1250000
SELECT population BETWEEN 1000000 AND 1250000
FROM world
WHERE population BETWEEN 1000000 AND 1250000
SELECT name, population FROM world
選擇你會從這個代碼獲得的結果。
      SELECT name, population
      FROM world
      WHERE name LIKE "Al%"
Table-A
Albania
Algeria
Table-B
%bania 3200000
%geria 32900000
Table-C
Al 0
Table-D
Albania 3200000
Table-E
Albania 3200000
Algeria 32900000
選擇代碼以顯示以“A”或“L” 結束的國家。
SELECT name FROM world
 WHERE name LIKE 'a%' AND name LIKE 'l%'
 
SELECT name FROM world
 WHERE name LIKE 'a%' OR name LIKE 'l%'
 
SELECT name FROM world
 WHERE name LIKE '%a' AND name LIKE '%l'
 
SELECT name FROM world
 WHERE name LIKE '%a' OR 'l%'
SELECT name FROM world
 WHERE name LIKE '%a' OR name LIKE '%l'
選擇查詢的結果。
SELECT name,length(name)
FROM world
WHERE length(name)=5 and region='Europe'
namelength(name)
Benin5
Lybia5
Egypt5
namelength(name)
Italy5
Egypt5
Spain5
namelength(name)
Italy5
Malta5
Spain5
namelength(name)
Italy5
France6
Spain5
namelength(name)
Sweden6
Norway6
Poland6
這是world表格的開首數行記錄
name region area population gdp
Afghanistan South Asia 652225 26000000
Albania Europe 28728 3200000 6656000000
Algeria Middle East 2400000 32900000 75012000000
Andorra Europe 468 64000
...
選擇你會從這個代碼獲得的結果。
SELECT name, area*2 FROM world WHERE population = 64000
Andorra234
Andorra468
Andorra936
Andorra4680
Andorra936
Albania57456
選擇代碼以顯示面積大於50000,人口少過1000萬(10000000)的國家。
SELECT name, area, population
  FROM world
 WHERE area < 50000 AND population < 10000000
SELECT name, area, population
  FROM world
 WHERE area < 50000 AND population > 10000000
SELECT name, area, population
  FROM world
 WHERE area > 50000 AND population < 10000000
SELECT name, area, population
  FROM world
 WHERE area > 50000 AND population > 10000000
 
SELECT name, area, population
  FROM world
 WHERE area = 50000 AND population = 10000000
選擇代碼以顯示中國,澳大利亞,尼日利亞和法國的人口密度。
 
SELECT name, area/population
FROM world WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
SELECT name, area/population
FROM world WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')
SELECT name, population/area
  FROM world
 WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
SELECT name, population/area
  FROM world
 WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')
SELECT name, population
  FROM world
 WHERE name IN ('China', 'Nigeria', 'France', 'Australia')