SUM and COUNT Quiz - Revision history

Andr3w at 14:14, 9 May 2013

2013-05-09T14:14:56Z

Andr3w at 14:13, 9 May 2013

2013-05-09T14:13:05Z

Andr3w at 14:12, 9 May 2013

2013-05-09T14:12:45Z

Andr3w at 14:11, 9 May 2013

2013-05-09T14:11:12Z

146.176.164.58 at 14:06, 9 May 2013

2013-05-09T14:06:49Z

91.89.5.124 at 20:22, 19 September 2012

2012-09-19T20:22:01Z

Connor at 10:43, 7 August 2012

2012-08-07T10:43:27Z

Connor at 10:42, 7 August 2012

2012-08-07T10:42:29Z

Connor at 10:33, 7 August 2012

2012-08-07T10:33:42Z

Connor at 10:11, 7 August 2012

2012-08-07T10:11:11Z

@@ Line 112: / Line 112: @@
 - Table-A
 - Table-B
-- Table-C
++ Table-C
-+ Table-D
+- Table-D
 - Table-E

@@ Line 108: / Line 108: @@
 <table><caption>Table-C</caption><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
 <table><caption>Table-D</caption><tr><td>Africa</td><td class="r">22550927</td></tr><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Asia-Pacific</td><td class="r">28759578</td></tr><tr><td>Europe</td><td class="r">23866987</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>North America</td><td class="r">21660000</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
-<table><caption>Table-D</caption><tr><td>Africa</td><td class="r">false</td></tr><tr><td>Americas</td><td class="r">true</td></tr><tr><td>Asia-Pacific</td><td class="r">false</td></tr><tr><td>Europe</td><td class="r">false</td></tr><tr><td>Middle East</td><td class="r">true</td></tr><tr><td>North America</td><td class="r">false</td></tr><tr><td>South America</td><td class="r">false</td></tr><tr><td>South Asia</td><td class="r">false</td></tr></table>
+<table><caption>Table-E</caption><tr><td>Africa</td><td class="r">false</td></tr><tr><td>Americas</td><td class="r">true</td></tr><tr><td>Asia-Pacific</td><td class="r">false</td></tr><tr><td>Europe</td><td class="r">false</td></tr><tr><td>Middle East</td><td class="r">true</td></tr><tr><td>North America</td><td class="r">false</td></tr><tr><td>South America</td><td class="r">false</td></tr><tr><td>South Asia</td><td class="r">false</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 108: / Line 108: @@
 <table><caption>Table-C</caption><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
 <table><caption>Table-D</caption><tr><td>Africa</td><td class="r">22550927</td></tr><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Asia-Pacific</td><td class="r">28759578</td></tr><tr><td>Europe</td><td class="r">23866987</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>North America</td><td class="r">21660000</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
-<table><caption>Table-E</caption><tr><td>Africa</td></tr><tr><td>Americas</td></tr><tr><td>Asia-Pacific</td>28759578</td></tr><tr><td>Europe</td></tr><tr><td>Middle East</td></tr><tr><td>North America</td></tr><tr><td>South America</td></tr><tr><td>South Asia</td></tr></table>
+<table><caption>Table-D</caption><tr><td>Africa</td><td class="r">false</td></tr><tr><td>Americas</td><td class="r">true</td></tr><tr><td>Asia-Pacific</td><td class="r">false</td></tr><tr><td>Europe</td><td class="r">false</td></tr><tr><td>Middle East</td><td class="r">true</td></tr><tr><td>North America</td><td class="r">false</td></tr><tr><td>South America</td><td class="r">false</td></tr><tr><td>South Asia</td><td class="r">false</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 106: / Line 106: @@
 <table style='float:left'><caption>Table-A</caption><tr><td class="r">732240</td></tr><tr><td class="r">13403102</td></tr><tr><td class="r">17740392</td></tr><tr><td class="r">4943771</td></tr></table>
 <table style='float:left'><caption>Table-B</caption><tr><td>Africa</td><td class="r">22550927</td></tr><tr><td>Asia-Pacific</td><td class="r">28759578</td></tr><tr><td>Europe</td><td class="r">23866987</td></tr><tr><td>North America</td><td class="r">21660000</td></tr></table>
-<table class="sqlmine"><caption>Table-C</caption><tr><th>region</th><th>SUM(area)</th></tr><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
+<table><caption>Table-C</caption><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
+<table><caption>Table-D</caption><tr><td>Africa</td><td class="r">22550927</td></tr><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Asia-Pacific</td><td class="r">28759578</td></tr><tr><td>Europe</td><td class="r">23866987</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>North America</td><td class="r">21660000</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 104: / Line 104: @@
 {Pick the result that would be obtained from the following code: SELECT region, SUM(area) FROM bbc GROUP BY region HAVING SUM(area)<= 20000000
-<table style='float:left'><caption>Table-A</caption><tr><td>732240</td></tr><tr><td>13403102</td></tr><tr><td>17740392</td></tr><tr><td>4943771</td></tr></table>
+<table style='float:left'><caption>Table-A</caption><tr><td class="r">732240</td></tr><tr><td class="r">13403102</td></tr><tr><td class="r">17740392</td></tr><tr><td class="r">4943771</td></tr></table>
-<table style='float:left'><caption>Table-B</caption><tr><td>Africa</td><td>22550927</td></tr><tr><td>Asia-Pacific</td><td>28759578</td></tr><tr><td>Europe</td><td>23866987</td></tr><tr><td>North America</td><td>21660000</td></tr></table>
+<table style='float:left'><caption>Table-B</caption><tr><td>Africa</td><td class="r">22550927</td></tr><tr><td>Asia-Pacific</td><td class="r">28759578</td></tr><tr><td>Europe</td><td class="r">23866987</td></tr><tr><td>North America</td><td class="r">21660000</td></tr></table>
-<table style='float:left'><caption>Table-C</caption><tr><td>Africa</td></tr><tr><td>Asia-Pacific</td></tr><tr><td>Europe</td></tr><tr><td>North America</td></tr></table>
+<table class="sqlmine"><caption>Table-C</caption><tr><th>region</th><th>SUM(area)</th></tr><tr><td>Americas</td><td class="r">732240</td></tr><tr><td>Middle East</td><td class="r">13403102</td></tr><tr><td>South America</td><td class="r">17740392</td></tr><tr><td>South Asia</td><td class="r">4943771</td></tr></table>
-<table style='float:left'><caption>Table-D</caption><tr><td>Americas</td><td>732240</td></tr><tr><td>Middle East</td><td>13403102</td></tr><tr><td>South America</td><td>17740392</td></tr><tr><td>South Asia</td><td>49437710</td></tr></table>
-<table style='float:left'><caption>Table-E</caption><tr><td>Americas</td></tr><tr><td>Middle East</td></tr><tr><td>South America</td></tr><tr><td>South Asia</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 74: / Line 74: @@
 |type="()"}
 - Table-A
-+ Table-B
+- Table-B
 - Table-C
 - No result due to invalid use of the GROUP BY function
-- No result due to invalid use of the WHERE function
++ No result due to invalid use of the WHERE function
 {Select the statement that shows the average population of 'Poland', 'Germany' and 'Denmark'

@@ Line 113: / Line 113: @@
 - Table-B
 - Table-C
-- Table-D
++ Table-D
 - Table-E

@@ Line 71: / Line 71: @@
 <table style='float:left'><caption>Table-A</caption><tr><td>Europe</td><td>17000000</td></tr></table>
 <table style='float:left'><caption>Table-B</caption><tr><td>Europe</td><td>17000000</td></tr><tr><td>Asia-Pacific</td><td>23460000</td></tr><tr><td>North America</td><td>21660000</td></tr></table>
-<table style='float:left'><caption>Table-C</caption><tr><td>Europe</td><td></td></tr><tr><td>Asia-Pacific</td><td></td></tr><tr><td>North America</td><td></td></tr></table>
+<table style='float:left'><caption>Table-C</caption><tr><td>Europe</td></tr><tr><td>Asia-Pacific</td></tr><tr><td>North America</td></tr></table>
 |type="()"}
 - Table-A
-- Table-B
++ Table-B
-+ Table-C
+- Table-C
 - No result due to invalid use of the GROUP BY function
 - No result due to invalid use of the WHERE function
@@ Line 103: / Line 103: @@
 - SELECT name, population/area AS density FROM bbc WHERE population > (SELECT MAX(population) FROM bbc)
-{Pick the result that would be obtained from the following code:
+{Pick the result that would be obtained from the following code: SELECT region, SUM(area) FROM bbc GROUP BY region HAVING SUM(area)<= 20000000
 |type="()"}
 - Table-A
 - Table-B
-+ Table-C
+- Table-C
 - Table-D
 - Table-E

@@ Line 67: / Line 67: @@
 - AVG(), COUNT(), MAX(), MIN(), SUM()
 - COUNT(), SUM()
 {Select the statement that shows the average population of 'Poland', 'Germany' and 'Denmark'
 |type="()"}
--A. SELECT AVG(population) FROM bbc WHERE name = ('Poland', 'Germany', 'Denmark')
+- SELECT AVG(population) FROM bbc WHERE name = ('Poland', 'Germany', 'Denmark')
-+B. SELECT AVG(population) FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark')
++ SELECT AVG(population) FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark')
--C. SELECT AVG(population) FROM bbc WHERE name LIKE ('Poland', 'Germany', 'Denmark')
+- SELECT AVG(population) FROM bbc WHERE name LIKE ('Poland', 'Germany', 'Denmark')
--D. SELECT AVG(population) FROM bbc WHERE name LIKE (Poland, Germany, Denmark)
+- SELECT AVG(population) FROM bbc WHERE name LIKE (Poland, Germany, Denmark)
--E. SELECT population FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark')
+- SELECT population FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark')
 {Select the statement that shows the medium population density of each region
 |type="()"}
--A. SELECT region, AVG(population/area) AS density FROM bbc
+- SELECT region, AVG(population/area) AS density FROM bbc
--B. SELECT region, COUNT(population)/COUNT(area) AS density FROM bbc GROUP BY region
+- SELECT region, COUNT(population)/COUNT(area) AS density FROM bbc GROUP BY region
--C. SELECT region, SUM(population)/COUNT(area) AS density FROM bbc GROUP BY region
+- SELECT region, SUM(population)/COUNT(area) AS density FROM bbc GROUP BY region
--D. SELECT region, SUM(population)/SUM(area) AS density FROM bbc HAVING region
+- SELECT region, SUM(population)/SUM(area) AS density FROM bbc HAVING region
-+E. SELECT region, SUM(population)/SUM(area) AS density FROM bbc GROUP BY region
++ SELECT region, SUM(population)/SUM(area) AS density FROM bbc GROUP BY region
 {Select the statement that shows the name and population density of the country with the largest population
 |type="()"}
--A. SELECT name, density AS population/area FROM bbc WHERE population = MAX(population)
+- SELECT name, density AS population/area FROM bbc WHERE population = MAX(population)
--B. SELECT name, density AS population/area FROM bbc WHERE population = (SELECT MAX(population) FROM bbc)
+- SELECT name, density AS population/area FROM bbc WHERE population = (SELECT MAX(population) FROM bbc)
--C. SELECT name, MAX (population) FROM bbc WHERE population / (SELECT area FROM bbc)
+- SELECT name, MAX (population) FROM bbc WHERE population / (SELECT area FROM bbc)
-+D. SELECT name, population/area AS density FROM bbc WHERE population = (SELECT MAX(population) FROM bbc)
++ SELECT name, population/area AS density FROM bbc WHERE population = (SELECT MAX(population) FROM bbc)
--E. SELECT name, population/area AS density FROM bbc WHERE population > (SELECT MAX(population) FROM bbc)
+- SELECT name, population/area AS density FROM bbc WHERE population > (SELECT MAX(population) FROM bbc)
 </quiz>
 [[Category:Quizzes]]