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

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 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 ⁹ which is 6.23 x 1,000,000,000 which is 6,230,000,000A Million is 10 ⁶ which is 1,000,000A Billion is 10 ⁹ which is one thousand million which is 1,000,000,000A Trillion is 10 ¹² , which is one million million which is 1,000,000,000,000.