Peter at 19:58, 21 August 2012

2012-08-21T19:58:27Z

Connor at 11:11, 12 July 2012

2012-07-12T11:11:14Z

Connor: Created page with "

BBC Country Profiles.

Some points to note:

There is a table called bbc with nearly 200 records.
The first record i..."
2012-07-11T08:28:00Z

Created page with "<h3 class="1">BBC Country Profiles.</h3> <p>Some points to note:</p> <ul> <li>There is a table called <code>bbc</code> with nearly 200 records.</li> <li>The first record i..."

New page
<h3 class="1">BBC Country Profiles.</h3>
<p>Some points to note:</p>
<ul>
<li>There is a table called <code>bbc</code> with nearly 200 records.</li>
<li>The first record is <code>Afghanistan</code> in <code>Asia</code> </li>
<li>The final record is <code>Zimbabwe</code> in <code>Africa</code>.</li>
<li>The table has five columns or <code>attributes</code> . These are:
<ul>
<li><code>name</code></li>
<li><code>region</code></li>
<li><code>area</code></li>
<li><code>population</code></li>
<li><code>gdp</code></li>
</ul>
</li>
</ul>

<h3>An extract from the table <code>bbc</code></h3>
<table border='1' id='usrResult0' ><tr>
<th>name</th>
<th>region</th>
<th>area</th>
<th>population</th>
<th>gdp</th>
</tr>
<tr><td >Yemen</td>
<td >Middle East</td>
<td align='right'>536869</td>
<td align='right'>21500000</td>
<td align='right'>12255000000</td>
</tr>
<tr><td >Zambia</td>
<td >Africa</td>
<td align='right'>752614</td>
<td align='right'>11000000</td>
<td align='right'>4950000000</td>
</tr>
<tr><td >Zimbabwe</td>
<td >Africa</td>
<td align='right'>390759</td>
<td align='right'>12900000</td>
<td align='right'>6192000000</td>
</tr>
</table>

<h3>Footnotes</h3>

<h2>Per Capita GDP</h2>
<p>The per capita GDP is the GDP divided by the population. It is
a rough measure of the average salary. A rich country is one with
a high per capita GDP.</p>

<h2>Original source</h2>

<p>This data has been collected from the BBC country profiles - it
may be a little out of date. The latest version can be found at
http://news.bbc.co.uk/1/hi/world/default.stm
http://news.bbc.co.uk/1/hi/world/default.stm.
Some changes have been made to the data - the reader should assume
that errors and omissions are due to me and not the peerless BBC.</p>

<h2>Area</h2>

<p>The area is measured in square kilometers.</p>

<h2>GDP</h2>

<p>I have taken the liberty of multiplying the GNI per capita (as published
by the BBC) by the population. I am pretty sure that this is not correct
but these tutorials are about databases not about economics.
</p>

<h2>Scientific Notation</h2>

<p>Some implementations of SQL may show large numbers in
scientific notation. The number
'''6.23 E9'''

means 6.23 x 10
<sup>9</sup>

which is 6.23 x 1,000,000,000 which is 6,230,000,000
<br/>A Million is
10
<sup>6</sup>

which is 1,000,000
<br/>A Billion is 10
<sup>9</sup>

which is one thousand million which is 1,000,000,000
<br/>A Trillion
is 10
<sup>12</sup>

, which is one million million which is 1,000,000,000,000.</p>

← Older revision		Revision as of 19:58, 21 August 2012
Line 94:		Line 94:

	, which is one million million which is 1,000,000,000,000.</p>		, which is one million million which is 1,000,000,000,000.</p>
		+
		+
		+	{{Languages}}

@@ Line 55: / Line 55: @@
    <p>This data has been collected from the BBC country profiles - it
    may be a little out of date. The latest version can be found at
   http://news.bbc.co.uk/1/hi/world/default.stm
-     http://news.bbc.co.uk/1/hi/world/default.stm.
 Some changes have been made to the data - the reader should assume
    that errors and omissions are due to me and not the peerless BBC.</p>

Read the notes about this table. - Revision history

Peter at 19:58, 21 August 2012

Connor at 11:11, 12 July 2012

Connor: Created page with "

BBC Country Profiles.