SUM and COUNT - Revision history

Andr3w at 23:04, 8 December 2012

2012-12-08T23:04:42Z

2012-12-08T23:04:27Z

2012-08-15T11:54:35Z

2012-08-06T08:45:59Z

2012-07-27T14:17:42Z

2012-07-27T14:15:52Z

2012-07-27T14:15:07Z

2012-07-27T01:30:30Z

2012-07-25T12:02:01Z

2012-07-24T14:51:35Z

@@ Line 1: / Line 1: @@
 <h3>World Country Profile: Aggregate functions</h3>
 This tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes many values and delivers just one value. For example the function SUM would aggregate the values 2, 4 and 5 to deliver the single value 11.
 <div class="ref_section">
 <table class='db_ref'>

@@ Line 159: / Line 159: @@
 <div class="lsclear">Clear your results</div>
-<p>[[SUM and COUNT Quiz]]</p>
+<p><div class="quizlink">[[SUM and COUNT Quiz]]</div></p>
 <p>[[The nobel table can be used to practice more SUM and COUNT functions.]]</p>
 <p>[[The_JOIN_operation |The next tutorial is looks at the Table Tennis database. It shows how queries may use records from two related tables.]]

@@ Line 1: / Line 1: @@
 <h3>BBC Country Profile: Aggregate functions</h3>
 This tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes many values and delivers just one value. For example the function SUM would aggregate the values 2, 4 and 5 to deliver the single value 11.
 <h2>Exercises</h2>

@@ Line 116: / Line 116: @@
 <div class="lsclear">Clear your results</div>
 <p>[[SUM and COUNT Quiz]]</p>
 <p>[[The nobel table can be used to practice more SUM and COUNT functions.]]</p>
 <p>[[The_JOIN_operation |The next tutorial is looks at the Table Tennis database. It shows how queries may use records from two related tables.]]

@@ Line 13: / Line 13: @@
 <div class='qu'>
 Show the total '''population''' of the world.
   bbc('''name''', '''region''', '''area''', '''population''', '''gdp''')
 <source lang='sql' class='def'>
 SELECT SUM(population)

@@ Line 5: / Line 5: @@
 <p>[[Using SUM, Count, MAX, DISTINCT and ORDER BY]].</p>
-<div class="summary">Summary</div>
+<div class="progress_panel"><div>
+   <div class="summary">Summary</div>
-<div class="progressbarbg">
+   <div class="progressbarbg">
-  <div class="progressbar"></div>
+     <div class="progressbar"></div>
-</div>
+   </div>
 <div class='qu'>

@@ Line 54: / Line 54: @@
 <source lang='sql' class='ans'>
-SELECT COUNT(region)
+SELECT COUNT(name)
 FROM bbc
 WHERE area >= 1000000

@@ Line 111: / Line 111: @@
 </div>
-<div class="lsclear">Clear you results</div>
+<div class="lsclear">Clear your results</div>
 <h2>What next</h2>