Difference between revisions of "SELECT Quiz"

From SQLZOO
Jump to: navigation, search
Line 90: Line 90:
 
- SELECT name, population FROM bbc WHERE name IN ('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%'
+
{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><tr><td>Algeria</td><td>Middle East</td></tr><tr><td>Angola</td><td>Africa</td></tr></table>
 
|type="()"}
 
|type="()"}
 
- (Algeria, Middle East), 32900000,  (Angola, Africa), 14500000
 
- (Algeria, Middle East), 32900000,  (Angola, Africa), 14500000
Line 100: Line 100:
  
 
[[Category:Quizzes]]
 
[[Category:Quizzes]]
 +
<table><tr><td>Algeria</td><td>Middle East</td></tr><tr><td>Angola</td><td>Africa</td></tr></table>

Revision as of 08:32, 7 August 2012

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

1. Select the code which shows the countries with a population between 100000000 and 200000000

SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000)
SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000
SELECT name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000
SELECT name, population FROM bbc WHERE area BETWEEN 100000000 AND 200000000
SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000

2. Select the code which shows the countries that end in A or L

SELECT name FROM bbc WHERE name LIKE '%a' AND 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'
SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%'

3. Pick the code which shows the total population of Scandinavia (Denmark, Finland, Sweden and Norway)

SELECT SUM(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden')
SELECT population FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden')
SELECT SUM(population) FROM bbc WHERE name IN 'Scandinavia'
SELECT SUM(population) FROM bbc WHERE name LIKE ('Denmark', 'Norway', 'Finland','Sweden')
SELECT TOTAL(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden')

4. Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000

Andorra, 234
Andorra, 468
Andorra, 936
Andorra, 4680
Andorra, 936, Albania, 57456

5. Select the code that would show the countries with an area larger than 50000 and a population smaller than 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 name, area, population FROM bbc WHERE area < 50000 AND population > 10000000

6. Select the code that shows the population density of China, Australia, Nigeria and France

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')

7. 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%'
AlgeriaMiddle East
AngolaAfrica
(Algeria, Middle East), 32900000, (Angola, Africa), 14500000
Algeria, 32900000, Angola, 14500000
AlgeriaMiddle East, 32900000, AngolaAfrica, 14500000
AngolaAfrica, 14500000[File:test.gif]
AlgeriaMiddle East
AngolaAfrica

Your score is 0 / 0
AlgeriaMiddle East
AngolaAfrica
Retrieved from "http://sqlzoo.net/w/index.php?title=SELECT_Quiz&oldid=3203"
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense