Difference between revisions of "Read the notes about this table."
(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...")
Revision as of 08:28, 11 July 2012
BBC Country Profiles.
Some points to note:
- There is a table called
bbcwith nearly 200 records.
- The first record is
- The final record is
- The table has five columns or
attributes. These are:
An extract from the table
Per Capita GDP
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.
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.
The area is measured in square kilometers.
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.
Some implementations of SQL may show large numbers in
scientific notation. The number
means 6.23 x 10
which is 6.23 x 1,000,000,000 which is 6,230,000,000
A Million is 10 6 which is 1,000,000
A Billion is 10 9 which is one thousand million which is 1,000,000,000
A Trillion is 10 12 , which is one million million which is 1,000,000,000,000.