SELECT Quiz - Revision history

Marek at 13:38, 15 August 2012

2012-08-15T13:38:18Z

Marek at 13:37, 15 August 2012

2012-08-15T13:37:57Z

Andr3w at 19:59, 11 August 2012

2012-08-11T19:59:44Z

Connor at 13:25, 7 August 2012

2012-08-07T13:25:03Z

Connor at 10:23, 7 August 2012

2012-08-07T10:23:19Z

Connor at 10:20, 7 August 2012

2012-08-07T10:20:47Z

Connor at 10:13, 7 August 2012

2012-08-07T10:13:47Z

Connor at 10:11, 7 August 2012

2012-08-07T10:11:53Z

Connor at 09:42, 7 August 2012

2012-08-07T09:42:50Z

Marek at 09:24, 7 August 2012

2012-08-07T09:24:45Z

@@ Line 84: / Line 84: @@
 - Table-A
 - Table-B
-+ Table-C
+- Table-C
 - Table-D
-- Table-E
++ Table-E
 {Select the code which shows the countries that end in A or L

@@ Line 49: / Line 49: @@
 - SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000
 - SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000
 {Select the code which shows the countries that end in A or L

@@ Line 44: / Line 44: @@
 {Select the code which shows the countries with a population between 100000000 and 200000000
 |type="()"}
 - 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 name, population FROM bbc WHERE population BETWEEN 100000000, 200000000
 - SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000
 {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 'l%'
 + SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l'
 {Pick the code which shows the total population of Scandinavia (Denmark, Finland, Sweden and Norway)
 |type="()"}
 - 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')
@@ Line 81: / Line 81: @@
 {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 the code that shows the population density of China, Australia, Nigeria and France

@@ Line 72: / Line 72: @@
 <table style='float:left'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table>
 <table style='float:left'><caption>Table-E</caption><tr><td>Andorra</td><td>936</td></tr><tr><td>Albania</td><td>57456</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 67: / Line 67: @@
 {Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000
-<table class='NoBorder'><td><tr>
+<table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table>
-<table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table></td>
+<table style='float:left'><caption>Table-B</caption><tr><td>Andorra</td><td>468</td></tr></table>
-<td><table style='float:left'><caption>Table-B</caption><tr><td>Andorra</td><td>468</td></tr></table></td>
+<table style='float:left'><caption>Table-C</caption><tr><td>Andorra</td><td>936 </td></tr></table>
-<td><table style='float:left'><caption>Table-C</caption><tr><td>Andorra</td><td>936 </td></tr></table></td>
+<table style='float:left'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table>
-<td><table style='float:left'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table></td>
+<table style='float:left'><caption>Table-E</caption><tr><td>Andorra</td><td>936</td></tr><tr><td>Albania</td><td>57456</td></tr></table>
-<td><table style='float:left'><caption>Table-E</caption><tr><td>Andorra</td><td>936</td></tr><tr><td>Albania</td><td>57456</td></tr></table></td>
-</tr></table>
 |type="()"}
 - Table-A

@@ Line 67: / Line 67: @@
 {Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000
-<table class='float'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table>
+<table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table>
-<table class='float'><caption>Table-B</caption><tr><td>Andorra</td><td>468</td></tr></table>
+<table style='float:left'><caption>Table-B</caption><tr><td>Andorra</td><td>468</td></tr></table>
-<table class='float'><caption>Table-C</caption><tr><td>Andorra</td><td>936 </td></tr></table>
+<table style='float:left'><caption>Table-C</caption><tr><td>Andorra</td><td>936 </td></tr></table>
-<table class='float'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table>
+<table style='float:left'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table>
-<table class='float'><caption>Table-E</caption><tr><td>Andorra</td><td>936</td></tr><tr><td>Albania</td><td>57456</td></tr></table>
+<table style='float:left'><caption>Table-E</caption><tr><td>Andorra</td><td>936</td></tr><tr><td>Albania</td><td>57456</td></tr></table>
 |type="()"}
 - Table-A
@@ Line 96: / Line 96: @@
 {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 class='float'><caption>Table-A</caption><tr><td>(Algeria, Middle East)</td><td>32900000</td></tr><tr><td>(Angola, Africa)</td><td>14500000</td></tr></table>
+<table style='float:left'><caption>Table-A</caption><tr><td>(Algeria, Middle East)</td><td>32900000</td></tr><tr><td>(Angola, Africa)</td><td>14500000</td></tr></table>
-<table class='float'><caption>Table-B</caption><tr><td>Algeria</td><td>32900000</td></tr><tr><td>Angola</td><td>14500000</td></tr></table>
+<table style='float:left'><caption>Table-B</caption><tr><td>Algeria</td><td>32900000</td></tr><tr><td>Angola</td><td>14500000</td></tr></table>
-<table class='float'><caption>Table-C</caption><tr><td>AlgeriaMiddle East</td><td>32900000</td></tr><tr><td>AngolaAfrica</td><td>14500000</td></tr></table>
+<table style='float:left'><caption>Table-C</caption><tr><td>AlgeriaMiddle East</td><td>32900000</td></tr><tr><td>AngolaAfrica</td><td>14500000</td></tr></table>
-<table class='float'><caption>Table-D</caption><tr><td>AngolaAfrica</td><td> 14500000</td></tr></table>
+<table style='float:left'><caption>Table-D</caption><tr><td>AngolaAfrica</td><td> 14500000</td></tr></table>
-<table class='float'><caption>Table-E</caption><tr><td>Algeria</td><td>Middle East</td></tr><tr><td>Angola</td><td>Africa</td></tr></table>
+<table style='float:left'><caption>Table-E</caption><tr><td>Algeria</td><td>Middle East</td></tr><tr><td>Angola</td><td>Africa</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 67: / Line 67: @@
 {Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000
 |type="()"}
-- Andorra, 234
+- Table-A
-- Andorra, 468
+- Table-B
-+ Andorra, 936
++ Table-C
-- Andorra, 4680
+- Table-D
-- Andorra, 936,  Albania, 57456
+- Table-E
 {Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000
@@ Line 91: / Line 96: @@
 {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><caption>E</caption><tr><td>Algeria</td><td>Middle East</td></tr><tr><td>Angola</td><td>Africa</td></tr></table>
+<table><caption>Table-A</caption><tr><td>(Algeria, Middle East)</td><td>32900000</td></tr><tr><td>(Angola, Africa)</td><td>14500000</td></tr></table>
 |type="()"}
-- ::(Algeria, Middle East) :32900000 ::(Angola, Africa) :14500000
+- Table-A
-- Algeria, 32900000,   Angola, 14500000
+- Table-B
-+ AlgeriaMiddle East, 32900000,   AngolaAfrica, 14500000
++ Table-C
-- AngolaAfrica, 14500000
+- Table-D
-- E
+- Table-E
 </quiz>
 [[Category:Quizzes]]