SELECT Quiz
From SQLZoo
| Language: Project:Language policy | English • 日本語 • 中文 |
|---|
Some questions concerning basic SQL statements
| 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 the code which produces this table
| 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
Pick the result you would obtain from this code:
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
Select the code which shows the countries that end in A or 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'
Pick the result from the query
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 |
Here are the first few rows of the world table:
Pick the result you would obtain from this code:
| 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
Select the code that would show the countries with an area larger than 50000 and a population smaller than 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
Select the code that shows the population density of China, Australia, Nigeria and 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&oldid=39723"