Nested SELECT Quiz

From SQLZoo
Language: Project:Language policy English  • 日本語  • 中文

Nested SELECT quiz

bbc
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
...
Select the code that shows the name, region and population of the smallest country in each region 
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)
Select the code that shows the countries belonging to regions with all populations over 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)
Select the code that shows the countries with a less than a third of the population of the countries around it 
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)
Select the result that would be obtained from the following code: 
SELECTnameFROMbbc
WHEREpopulation>
(SELECTpopulation
FROMbbc
WHEREname='United Kingdom')
ANDregionIN
(SELECTregion
FROMbbc
WHEREname='United Kingdom')
Table-A
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
Select the code that would show the countries with a greater GDP than any country in Africa (some countries may have NULL gdp values). 
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)
Select the code that shows the countries with population smaller than Russia but bigger than Denmark 
SELECTnameFROMbbc
WHEREpopulation<(SELECTpopulationFROMbbcWHEREname='Denmark')
ANDpopulation>(SELECTpopulationFROMbbcWHEREname='Russia')

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')
SELECT name FROM bbc
 WHERE population < (SELECT population FROM bbc WHERE name='Russia'
 AND population > (SELECT population FROM bbc WHERE name='Denmark')
>Select the result that would be obtained from the following code: 
SELECT name FROM bbc
 WHERE population > ALL
 (SELECT MAX(population)
 FROM bbc
 WHERE region = 'Europe')
 AND region = 'South Asia'
Table-A
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
Kaleidoscope - get a kaleidoscope view using your phone/laptop camera
  • Served by: noddy at 2026年07月05日T09:27