Difference between revisions of "BBC QUIZ"

From SQLZOO
Jump to: navigation, search
 
(16 intermediate revisions by one other user not shown)
Line 1: Line 1:
BBC QUIZ
 
 
<div class='ref_section'>
 
<div class='ref_section'>
 
<table class='db_ref'>
 
<table class='db_ref'>
<caption>bbc</caption>
+
<caption>world</caption>
 
<tr>
 
<tr>
 
<th>name</th>
 
<th>name</th>
<th>region</th>
+
<th>continent</th>
 
<th>area</th>
 
<th>area</th>
 
<th>population</th>
 
<th>population</th>
Line 58: Line 57:
 
<td align='right'>9900</td>
 
<td align='right'>9900</td>
 
<td></td>
 
<td></td>
</tr>
 
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 73: Line 71:
 
</div>
 
</div>
  
<quiz shuffle=none display=simple>
+
<div class=quiz>
{Select the code which gives the name of countries beginning with U
+
<div class=q>Select the code which gives the name of countries beginning with U
|type="()"}
+
<syntaxhighlight class=d lang='sql'>
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name BEGIN with C </syntaxhighlight>
+
SELECT name
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%C' </syntaxhighlight>
+
  FROM world
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%C%' </syntaxhighlight>
+
WHERE name
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE U </syntaxhighlight>
+
BEGIN with U</syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE 'U%' </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'>
 
+
SELECT name
{Select the code which shows just the population of United Kingdom?
+
  FROM world
|type="()"}
+
WHERE name LIKE '%U' </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name Like 'United%' </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'>
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE population = 'United Kingdom' </syntaxhighlight>
+
SELECT name
- <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE name = 'United Kingdom' </syntaxhighlight>
+
  FROM world
+ <syntaxhighlight lang='sql'> SELECT population FROM bbc WHERE name = 'United Kingdom' </syntaxhighlight>
+
WHERE name LIKE '%u%' </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT population FROM bbc WHERE name = United Kingdom </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'>
 
+
SELECT name
{Select the answer which shows the problem with this SQL code:
+
  FROM world
 +
WHERE name LIKE U </syntaxhighlight>
 +
<syntaxhighlight class='d y' lang='sql'>
 +
SELECT name
 +
  FROM world
 +
WHERE name LIKE 'U%' </syntaxhighlight>
 +
</div>
 +
<div class=q>Select the code which shows just the population of United Kingdom?
 +
<syntaxhighlight class=d lang='sql'>
 +
SELECT population
 +
  FROM 'United Kingdom' </syntaxhighlight>
 +
<syntaxhighlight class=d lang='sql'>
 +
SELECT name
 +
  FROM world
 +
WHERE population = 'United Kingdom' </syntaxhighlight>
 +
<syntaxhighlight class=d lang='sql'>
 +
SELECT FROM world
 +
WHERE population IN 'United Kingdom' </syntaxhighlight>
 +
<syntaxhighlight class='d y' lang='sql'>
 +
SELECT population
 +
  FROM world
 +
WHERE name = 'United Kingdom' </syntaxhighlight>
 +
<syntaxhighlight class=d lang='sql'>
 +
SELECT population
 +
  FROM world
 +
WHERE 'United Kingdom' IN name </syntaxhighlight>
 +
</div>
 +
<div class=q>Select the answer which shows the problem with this SQL code - the indended result should be the single row containing 'France':
 
<syntaxhighlight lang='sql'>
 
<syntaxhighlight lang='sql'>
  SELECT name
+
  SELECT continent
   FROM "bbc"
+
   FROM world
   WHERE population > '2000000'
+
   WHERE 'name' = 'France'
 
</syntaxhighlight>
 
</syntaxhighlight>
|type="()"}
+
<div class=d>continent should be 'continent'</div>
- Apostrophes should be used around 'bbc' instead of speech marks
+
<div class='d y'>'name' should be name</div>
- There are apostrophes surrounding '2000000'
+
<div class=d>'France' should be "France"</div>
- There are speech marks surrounding "bbc"
+
<div class=d>'France' should be France</div>
+ There are speech marks surrounding "bbc" and there are apostrophes surrounding '2000000'
+
<div class=d>= should be IN</div>
- The use of a WHERE function is incorrect
+
</div>
 
+
<div class=q>Select the result that would be obtained from the following code:  
{Select the result that would be obtained from the following code:  
+
 
<syntaxhighlight lang='sql'>
 
<syntaxhighlight lang='sql'>
 
  SELECT name, population / 10  
 
  SELECT name, population / 10  
   FROM bbc
+
   FROM world
 
  WHERE population < 10000
 
  WHERE population < 10000
 
</syntaxhighlight>
 
</syntaxhighlight>
<table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>6400</td></tr><tr><td>Nauru</td><td>990</td></tr></table>
+
<table class=d><tr><td>Andorra</td><td>6400</td></tr><tr><td>Nauru</td><td>990</td></tr></table>
<table style='float:left'><caption>Table-B</caption><tr><td>Andorra</td><td>64000</td></tr><tr><td>Nauru</td><td>9900</td></tr></table>
+
<table class=d><tr><td>Andorra</td><td>64000</td></tr><tr><td>Nauru</td><td>9900</td></tr></table>
<table style='float:left'><caption>Table-C</caption><tr><td>Nauru</td><td>99</td></tr></table>
+
<table class=d><tr><td>Nauru</td><td>99</td></tr></table>
<table style='float:left'><caption>Table-D</caption><tr><td>Nauru</td><td>990</td></tr></table>
+
<table class='d y'><tr><td>Nauru</td><td>990</td></tr></table>
<table style='float:left'><caption>Table-E</caption><tr><td>Nauru</td><td>9900</td></tr></table>
+
<table class=d><tr><td>Nauru</td><td>9900</td></tr></table>
|type="()"}
+
</div>
- Table-A
+
<div class=q>Select the code which would reveal the name and population of countries in Europe and Asia
- Table-B
+
<syntaxhighlight class=d lang='sql'>
- Table-C
+
SELECT name
+ Table-D
+
  FROM world
- Table-E
+
WHERE continent IN ('Europe', 'Asia') </syntaxhighlight>
 
+
<syntaxhighlight class='d y' lang='sql'>
{Select the code which would reveal the name and population of countries in Europe, North America and South America
+
SELECT name, population
|type="()"}
+
  FROM world
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America') </syntaxhighlight>
+
WHERE continent IN ('Europe', 'Asia') </syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE region IN ('Europe', 'North America', 'South America') </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'>
- <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE region IN (Europe North America South America) </syntaxhighlight>
+
SELECT name, population
- <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE region IS ('Europe', 'North America', 'South America') </syntaxhighlight>
+
  FROM world
- <syntaxhighlight lang='sql'> SELECT population FROM bbc WHERE region IN ('Europe', 'North America', 'South America') </syntaxhighlight>
+
WHERE name IN (Europe Asia) </syntaxhighlight>
 
+
<syntaxhighlight class=d lang='sql'>
{Select the code which would give two rows
+
SELECT name, population
|type="()"}
+
  FROM world
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name = 'United Kingdom' </syntaxhighlight>
+
WHERE name IS ('Europe', 'Asia') </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name = 'United Kingdom' AND name = 'Algeria' </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'>
- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria') </syntaxhighlight>
+
SELECT name, population
+ <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') </syntaxhighlight>
+
  FROM world
- <syntaxhighlight lang='sql'> SELECT name FROM WHERE name IS 'Scotland' </syntaxhighlight>
+
WHERE continent = ('Europe', 'Asia') </syntaxhighlight>
 
+
</div>
{Select the result that would be obtained from this code:  
+
<div class=q >Select the code which would give two rows
<source lang='SQL'>SELECT name FROM bbc WHERE region = 'South America' AND population > 40000000</source>
+
<syntaxhighlight class=d lang='sql'>
<table style='float:left'><caption>Table-A</caption><tr><td>Afghanistan</td></tr><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
+
SELECT name FROM world
<table style='float:left'><caption>Table-B</caption><tr><td>Brazil</td></tr></table>
+
WHERE name = 'Cuba' </syntaxhighlight>
<table style='float:left'><caption>Table-C</caption><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
+
<syntaxhighlight class=d lang='sql'>
<table style='float:left'><caption>Table-D</caption><tr><td>Brazil</td><td>South America</td></tr><tr><td>Colombia</td><td>South America</td></tr></table>
+
SELECT name FROM world
<table style='float:left'><caption>Table-E</caption><tr><td>Brazil</td><td>182800000</td></tr><tr><td>Colombia</td><td>45600000</td></tr></table>
+
WHERE name = 'Cuba'
|type="()"}
+
  AND name = 'Togo' </syntaxhighlight>
- Table-A
+
<syntaxhighlight class=d lang='sql'>
- Table-B
+
SELECT name FROM world
+ Table-C
+
WHERE name EITHER ('Cuba', 'Togo') </syntaxhighlight>
- Table-D
+
<syntaxhighlight class='d y' lang='sql'>
- Table-E
+
SELECT name FROM world
</quiz>
+
WHERE name IN ('Cuba', 'Togo') </syntaxhighlight>
 +
<syntaxhighlight class=d lang='sql'>
 +
SELECT name FROM WHERE name IS 'Mali' </syntaxhighlight>
 +
</div>
 +
<div class=q>Select the result that would be obtained from this code:  
 +
<source lang='SQL'>
 +
SELECT name FROM world
 +
WHERE continent = 'South America'
 +
  AND population > 40000000</source>
 +
<table class=d><tr><td>Afghanistan</td></tr><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
 +
<table class=d><tr><td>Brazil</td></tr></table>
 +
<table class='d y'><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
 +
<table class=d><tr><td>Brazil</td><td>South America</td></tr><tr><td>Colombia</td><td>South America</td></tr></table>
 +
<table class=d><tr><td>Brazil</td><td>182800000</td></tr><tr><td>Colombia</td><td>45600000</td></tr></table>
 +
</div>
 +
</div>
 
[[Category:Quizzes]]
 
[[Category:Quizzes]]

Latest revision as of 08:30, 15 May 2015

world
name continent area population gdp
Afghanistan South Asia 652225 26000000
Albania Europe 28728 3200000 6656000000
Algeria Middle East 2400000 32900000 75012000000
Andorra Europe 468 64000
Brazil South America 8550000 182800000 564852000000
Colombia South America 1140000 45600000
Nauru Asia-Pacific 21 9900
Uzbekistan Central Asia 447000 26000000
...
Select the code which gives the name of countries beginning with U
SELECT name
  FROM world
 WHERE name
 BEGIN WITH U
SELECT name
  FROM world
 WHERE name LIKE '%U'
SELECT name
  FROM world
 WHERE name LIKE '%u%'
SELECT name
  FROM world
 WHERE name LIKE U
SELECT name
  FROM world
 WHERE name LIKE 'U%'
Select the code which shows just the population of United Kingdom?
SELECT population
  FROM 'United Kingdom'
SELECT name
  FROM world
 WHERE population = 'United Kingdom'
SELECT FROM world
 WHERE population IN 'United Kingdom'
SELECT population
  FROM world
 WHERE name = 'United Kingdom'
SELECT population
  FROM world
 WHERE 'United Kingdom' IN name
Select the answer which shows the problem with this SQL code - the indended result should be the single row containing 'France':
 SELECT continent 
   FROM world 
  WHERE 'name' = 'France'
continent should be 'continent'
'name' should be name
'France' should be "France"
'France' should be France
= should be IN
Select the result that would be obtained from the following code:
 SELECT name, population / 10 
  FROM world 
 WHERE population < 10000
Andorra6400
Nauru990
Andorra64000
Nauru9900
Nauru99
Nauru990
Nauru9900
Select the code which would reveal the name and population of countries in Europe and Asia
SELECT name
  FROM world 
 WHERE continent IN ('Europe', 'Asia')
SELECT name, population
  FROM world
 WHERE continent IN ('Europe', 'Asia')
SELECT name, population
  FROM world
 WHERE name IN (Europe Asia)
SELECT name, population
  FROM world
 WHERE name IS ('Europe', 'Asia')
SELECT name, population
  FROM world
 WHERE continent = ('Europe', 'Asia')
Select the code which would give two rows
SELECT name FROM world
 WHERE name = 'Cuba'
SELECT name FROM world
 WHERE name = 'Cuba'
   AND name = 'Togo'
SELECT name FROM world
 WHERE name EITHER ('Cuba', 'Togo')
SELECT name FROM world
 WHERE name IN ('Cuba', 'Togo')
SELECT name FROM WHERE name IS 'Mali'
Select the result that would be obtained from this code:
SELECT name FROM world
 WHERE continent = 'South America'
   AND population > 40000000
Afghanistan
Brazil
Colombia
Brazil
Brazil
Colombia
BrazilSouth America
ColombiaSouth America
Brazil182800000
Colombia45600000