SELECT Quiz

From SQLZOO
Revision as of 23:06, 29 August 2013 by Andr3w (Talk | contribs)

Jump to: navigation, search

SELECT quiz

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
...

<quiz shuffle=none display=simple>

{Select the code which produces this table
namepopulation
Bahrain1234571
Swaziland1220000
Timor-Leste1066409

|type="()"}

-
WHERE population BETWEEN 1000000 AND 1250000 SELECT name, population
  FROM world
-
SELECT population BETWEEN 1000000 AND 1250000 FROM world
+
SELECT name, population FROM world WHERE population BETWEEN 1000000 AND 1250000
-
FROM world SELECT name, population BETWEEN 1000000 AND 1250000
-
SELECT name, population WHERE population BETWEEN 1000000 AND 1250000 FROM world

{Pick the result you would obtain from this code:

SELECT name, population
  FROM bbc 
 WHERE name LIKE "Al%"
Table-A
Albania
Algeria
Table-B
%bania 3200000
%geria 32900000
Table-C
Al 0
Table-D
Albania 3200000
Table-E
Albania 3200000
Algeria 32900000

|type="()"} - Table-A - Table-B - Table-C - Table-D + Table-E

{Select the code which shows the countries that end in A or L |type="()"}

-
 SELECT name FROM bbc WHERE name LIKE 'a%' AND name LIKE 'l%'
-
 SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%'
-
 SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l'
-
 SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%'
+
 SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l'

{Pick the result from the query

 SELECT name,LENGTH(name)
   FROM world
  WHERE LENGTH(name)=5 AND continent='Europe'
Table-A
namelength(name)
Benin5
Lybia5
Egypt5
Table-B
namelength(name)
Italy5
Egypt5
Spain5
Table-C
namelength(name)
Italy5
Malta5
Spain5
Table-D
namelength(name)
Italy5
France6
Spain5
Table-E
namelength(name)
Sweden6
Norway6
Poland6

|type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E

{Pick the result you would obtain from this code:

SELECT name, area * 2 FROM bbc WHERE population = 64000
Table-A
Andorra234
Table-B
Andorra468
Table-C
Andorra936
Table-D
Andorra4680
Table-E
Andorra936
Albania57456

|type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E

{Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000 |type="()"}

-
 SELECT name, area, population FROM bbc WHERE area < 50000 AND population < 10000000
-
 SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000
+
 SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000
-
 SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000
-
 SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000

{Select the code that shows the population density of China, Australia, Nigeria and France |type="()"}

-
 SELECT name, area/population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
-
 SELECT name, area/population FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')
+
 SELECT name, population/area FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
-
 SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')
-
 SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')

{Pick the result that would be obtained from this code: SELECT CONCAT(name,region), population FROM bbc WHERE region IN ('Africa','Middle East') AND name LIKE 'A%'

Table-A
(Algeria, Middle East)32900000
(Angola, Africa)14500000
Table-B
Algeria32900000
Angola14500000
Table-C
AlgeriaMiddle East32900000
AngolaAfrica14500000
Table-D
AngolaAfrica 14500000
Table-E
AlgeriaMiddle East
AngolaAfrica

|type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E

</quiz>