SELECT Quiz/zh
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 | |
... |
選擇產生此表的代碼。
name | population |
---|---|
Bahrain | 1234571 |
Swaziland | 1220000 |
Timor-Leste | 1066409 |
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%"
Albania |
Algeria |
%bania | 3200000 |
%geria | 32900000 |
Al | 0 |
Albania | 3200000 |
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'
name | length(name) |
---|---|
Benin | 5 |
Lybia | 5 |
Egypt | 5 |
name | length(name) |
---|---|
Italy | 5 |
Egypt | 5 |
Spain | 5 |
name | length(name) |
---|---|
Italy | 5 |
Malta | 5 |
Spain | 5 |
name | length(name) |
---|---|
Italy | 5 |
France | 6 |
Spain | 5 |
name | length(name) |
---|---|
Sweden | 6 |
Norway | 6 |
Poland | 6 |
這是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
Andorra | 234 |
Andorra | 468 |
Andorra | 936 |
Andorra | 4680 |
Andorra | 936 |
Albania | 57456 |
選擇代碼以顯示面積大於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')