SELECT Quiz/ja
From SQLZoo
| Language: Project:Language policy | 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 |
FROMworld SELECTname,populationBETWEEN1000000AND1250000
FROMname,population WHEREpopulationBETWEEN1000000AND1250000 SELECTworld
SELECTname,population FROMworld WHEREpopulationBETWEEN1000000AND1250000
SELECTpopulationBETWEEN1000000AND1250000 FROMworld
WHEREpopulationBETWEEN1000000AND1250000 SELECTname,populationFROMworld
このコードの出力結果を選ぶ:
Table-A
SELECTname,population FROMworld WHEREnameLIKE"Al%"
Albania
Algeria
Table-B
%bania
3200000
%geria
32900000
Table-C Al
0
Table-D Albania
3200000
Table-E
Albania
3200000
Algeria
32900000
A または L で終わる国名を表示するコードを選ぶ。
SELECTnameFROMworld WHEREnameLIKE'a%'ANDnameLIKE'l%'
SELECTnameFROMworld WHEREnameLIKE'a%'ORnameLIKE'l%'
SELECTnameFROMworld WHEREnameLIKE'%a'ANDnameLIKE'%l'
SELECTnameFROMworld WHEREnameLIKE'%a'OR'l%'
SELECTnameFROMworld WHEREnameLIKE'%a'ORnameLIKE'%l'
このクエリーの出力結果を選ぶ。
SELECTname,length(name) FROMworld WHERElength(name)=5andregion='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を超えかつ人口が10000000未満の国を表示するコードを選ぶ。
SELECTname,area,population FROMworld WHEREarea<50000ANDpopulation<10000000
SELECTname,area,population FROMworld WHEREarea<50000ANDpopulation>10000000
SELECTname,area,population FROMworld WHEREarea>50000ANDpopulation<10000000
SELECTname,area,population FROMworld WHEREarea>50000ANDpopulation>10000000
SELECTname,area,population FROMworld WHEREarea=50000ANDpopulation=10000000
China, Australia, Nigeria, France の人口密度を表示するコードを選ぶ。
SELECTname,area/population FROMworldWHEREnameIN('China','Nigeria','France','Australia')
SELECTname,area/population FROMworldWHEREnameLIKE('China','Nigeria','France','Australia')
SELECTname,population/area FROMworld WHEREnameIN('China','Nigeria','France','Australia')
SELECTname,population/area FROMworld WHEREnameLIKE('China','Nigeria','France','Australia')
SELECTname,population FROMworld WHEREnameIN('China','Nigeria','France','Australia')
Retrieved from "https://sqlzoo.net/w/index.php?title=SELECT_Quiz/ja&oldid=39725"