SELECT basics - Revision history

Andr3w: /* Per Capita GDP */

2013-04-29T14:32:56Z

‎Per Capita GDP

2013-04-29T14:20:55Z

2013-04-17T15:53:46Z

‎Introducing the world table of countries

2013-04-17T15:53:33Z

2013-02-17T01:02:27Z

2013-02-15T16:02:13Z

2013-02-15T16:00:18Z

2013-01-17T09:25:14Z

2012-12-08T22:59:15Z

2012-12-08T21:05:26Z

@@ Line 45: / Line 45: @@
 ==Per Capita GDP==
 <div class='qu'>
-<div>This query shows the population density <code>population/area</code>
+<div>The query shows the population density <code>population/area</code>
 for each country where the area is over 5,000,000 km<sup>2</sup>.</div>
 <div class='imper'>Show the per capita gdp: <code>gdp/population</code>

@@ Line 15: / Line 15: @@
 ==Introducing the <code>world</code> table of countries==
-   <p>This  tutorial introduces SQL as a  query language.. We will be using the SELECT command on the table '''world''':</p>
+   <p>This  tutorial introduces SQL. We will be using the SELECT command on the table '''world''':</p>
 <div class="progress_panel"><div>

@@ Line 15: / Line 15: @@
 ==Introducing the <code>world</code> table of countries==
-   <p>This  tutorial introduces SQL as a  query language. We will be using the SELECT command on the table '''world''':</p>
+   <p>This  tutorial introduces SQL as a  query language.. We will be using the SELECT command on the table '''world''':</p>
 <div class="progress_panel"><div>

@@ Line 15: / Line 15: @@
 ==Introducing the <code>world</code> table of countries==
-   <p>This tutorial introduces SQL as a  query language. We will be using the SELECT command on the table '''world''':</p>
+   <p>This  tutorial introduces SQL as a  query language. We will be using the SELECT command on the table '''world''':</p>
 <div class="progress_panel"><div>

@@ Line 9: / Line 9: @@
 <td>Angola</td><td>Africa</td><td class="r">1246700	</td><td class="r">20609294	</td><td class="r">100990000000	</td></tr>
 <tr>
-<td colspan='5'>...</td>[[File:[[File:Example.jpg]][[File:[[File:Example.jpg]]'''Bold text''']]]]
+<td colspan='5'>...</td>
 </tr>
 </table>

@@ Line 138: / Line 138: @@
 <p><div class="quizlink">[[SELECT Quiz]]</div></p>
 </div>
-<p>You are ready for tutorial one:[[SELECT_from_BBC_Tutorial |SELECT statements with WHERE.]]</p>
+<p>You are ready for tutorial one:[[SELECT_from_WORLD_Tutorial |SELECT statements with WHERE.]]</p>
 {{Languages}}

@@ Line 3: / Line 3: @@
 <tr><th>name</th><th>continent</th><th>area</th>
 <th>population</th><th>gdp</th></tr>
-<tr><td>Afghanistan</td><td>Asia</td><td class="r">652230</td><td class="r">25500100</td><td class="r"></td></tr>
+<tr><td>Afghanistan</td><td>Asia</td><td class="r">652230</td><td class="r">25500100</td><td class="r">20343000000</td></tr>
 <tr><td>Albania</td><td>Europe</td><td class="r">28748	</td><td class="r">2831741	</td><td class="r">12960000000	</td></tr>
 <tr><td>Algeria</td><td>Africa</td><td class="r">2381741	</td><td class="r">37100000	</td><td class="r">188681000000	</td></tr>