## CIA World Factbook database.

Some points to note:

- There is a table called
`cia`

with 265 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 `cia`

name |
region |
area |
population |
gdp |

'Yemen' |
'Middle East' |
527970 |
14728474 |
23400000000 |

'Zaire' |
'Africa' |
2345410 |
44060636 |
18800000000 |

'Zambia' |
'Africa' |
752610 |
9445723 |
7900000000 |

'Zimbabwe' |
'Africa' |
390580 |
11139961 |
17400000000 |

## Footnotes

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 CIA World Factbook - it
may be a little out of date. The latest version can be found at
http://www.cia.gov
. The reader should assume that errors in the data are my fault
and not part of a CIA conspiracy.

### Area

The area is measured in square kilometers.

### GDP

The GDP is the Gross Domestic Product. It is a measure of the
total wealth generated by the country in US dollars in one
year.

### 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,000A Million is
10
^{6}
which is 1,000,000A Billion is 10
^{9}
which is one thousand million which is 1,000,000,000A Trillion
is 10
^{12}
, which is one million million which is 1,000,000,000,000.