# Difference between revisions of "Read the notes about this table."

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}} |

## Revision as of 19:58, 21 August 2012

## Contents

### BBC Country Profiles.

Some points to note:

- There is a table called
`bbc`

with nearly 200 records. - The first record is
`Afghanistan`

in`Asia`

- The final record is
`Zimbabwe`

in`Africa`

. - The table has five columns or
`attributes`

. These are:`name`

`region`

`area`

`population`

`gdp`

### An extract from the table `bbc`

name | region | area | population | gdp |
---|---|---|---|---|

Yemen | Middle East | 536869 | 21500000 | 12255000000 |

Zambia | Africa | 752614 | 11000000 | 4950000000 |

Zimbabwe | Africa | 390759 | 12900000 | 6192000000 |

### Footnotes

## 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.

## Original source

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 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.

## Area

The area is measured in square kilometers.

## GDP

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.

## Scientific Notation

Some implementations of SQL may show large numbers in
scientific notation. The number
**6.23 E9**
means 6.23 x 10
^{9}
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.

Language: | English • Deutsch |
---|