Nested SELECT Quiz/ja
From SQLZoo
| Language: Project:Language policy | English • 日本語 • 中文 |
|---|
ネストした SELECT クイズ
| 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 | |
| Bangladesh | South Asia | 143998 | 152600000 | 67144000000 |
| United Kingdom | Europe | 242514 | 59600000 | 2022824000000 |
| ... | ||||
各地域 region で最小の人口population を持つ国の、name, region, population を表示するコードを選べ。
SELECTregion,name,FROMbbcxWHEREpopulation<=ALL(SELECTpopulationFROMbbcyWHEREy.region=x.regionANDpopulation>0)
SELECTregion,name,populationFROMbbcWHEREpopulation<=ALL(SELECTpopulationFROMbbcWHEREpopulation>0)
SELECTregion,name,populationFROMbbcxWHEREpopulation<=ALL(SELECTpopulationFROMbbcyWHEREy.region=x.regionANDpopulation>0)
SELECTregion,name,populationFROMbbcxWHEREpopulation=ALL(SELECTpopulationFROMbbcyWHEREy.region=x.regionANDpopulation>0)
SELECTregion,name,populationFROMbbcxWHEREpopulation<=ALL(SELECTpopulationFROMbbcyWHEREy.region=x.regionANDpopulation<0)
その地区の全ての国が50000人を超える様な国を表示するコードを選べ。
SELECTname,region,populationFROMbbcxWHERE50000<ALL(SELECTpopulationFROMbbcyWHEREpopulation>0)
SELECTname,region,populationFROMbbcxWHERE50000<ALL(SELECTpopulationFROMbbcyWHEREx.region=y.regionANDy.population>0)
SELECTname,region,populationFROMbbcxWHERE50000=ALL(SELECTpopulationFROMbbcyWHEREx.region=y.regionANDy.population>0)
SELECTname,region,populationFROMbbcxWHERE50000>ALL(SELECTpopulationFROMbbcyWHEREx.region=y.regionANDy.population>0)
SELECTname,region,populationFROMbbcxWHERE500000<ALL(SELECTpopulationFROMbbcyWHEREx.region=y.regionANDy.population>0)
その国がある地域の他の国の3分の1より小さな人口の国を表示するコードを選べ。
SELECTname,regionFROMbbcx WHEREpopulation<ALL(SELECTpopulation/3FROMbbcyWHEREy.region=x.regionANDy.name!=x.name)
SELECTname,regionFROMbbcx WHEREpopulation=ALL(SELECTpopulation/3FROMbbcyWHEREy.region=x.regionANDy.name!=x.name)
SELECTname,regionFROMbbcx WHEREpopulation>ALL(SELECTpopulation/3FROMbbcyWHEREy.region=x.regionANDy.name!=x.name)
SELECTname,regionFROMbbcxWHEREpopulation<ALL(SELECTpopulation*3FROMbbcyWHEREy.region=x.regionANDy.name!=x.name)
SELECTname,regionFROMbbcxWHEREpopulation<ALL(SELECTpopulation/3FROMbbcyWHEREy.name!=x.name)
次のコードの実行結果を選べ
Table-A
SELECTnameFROMbbc WHEREpopulation> (SELECTpopulation FROMbbc WHEREname='United Kingdom') ANDregionIN (SELECTregion FROMbbc WHEREname='United Kingdom')
Andorra
Albania
Austria
Bulgaria
Table-B France Europe
Germany Europe
Russia Europe
Turkey Europe
Table-C France
Germany
Andorra
Albania
Table-D France
Germany
Russia
Turkey
Table-E France
Germany
Russia
Turkey
Brazil
United States of USA
Canada
アフリカAfrica のどの国のGDPよりも大きなGDPを持つ国を表示するコードを選べ。
SELECTnameFROMbbc WHEREgdp>ALL(SELECTMAX(gdp)FROMbbcWHEREregion='Africa'ANDgdp=0)
SELECTnameFROMbbc WHEREgdp>(SELECTMAX(gdp)FROMbbcWHEREregion='Africa')
SELECTnameFROMbbc WHEREgdp>ALL(SELECTMIN(gdp)FROMbbcWHEREregion='Africa')
SELECTnameFROMbbc WHEREgdp>ALL(SELECTgdpFROMbbcWHEREregion='Africa')
SELECTnameFROMbbc WHEREgdp>ALL(SELECTgdpFROMbbcWHEREregion='Africa'ANDgdp<>NULL)
ロシアRussia よりも小さく、デンマークDenmark よりも大きな人口を持つ国を表示するコードを選べ。
SELECTnameFROMbbc WHEREpopulation<(SELECTpopulationFROMbbcWHEREname='Denmark') ANDpopulation>(SELECTpopulationFROMbbcWHEREname='Russia')
SELECTnameFROMbbc WHEREpopulation<(SELECTpopulationFROMbbcWHEREname='Russia') ANDpopulation>(SELECTpopulationFROMbbcWHEREname='Denmark')
SELECTnameFROMbbc WHEREpopulation=(SELECTpopulationFROMbbcWHEREname='Russia') ANDpopulation>(SELECTpopulationFROMbbcWHEREname='Denmark')
SELECT name FROM bbc WHERE population > (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark')
SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Russia' AND population > (SELECT population FROM bbc WHERE name='Denmark')
次のコードの実行結果を選べ:
Table-A
SELECT name FROM bbc WHERE population > ALL (SELECT MAX(population) FROM bbc WHERE region = 'Europe') AND region = 'South Asia'
Afghanistan
Bhutan
Nepal
Sri Lanka
The Maldives
Table-B Bangladesh
India
Pakistan
Table-C China
India
Table-D Brazil
Bangladesh
China
India
Table-E France
Germany
Russia
Trukey