Read the notes about this table.
Some points to note:
- There is a table called
worldwith nearly 200 records.
- The first record is
- The final record is
- The table has eight columns or
attributes. These are:
Field Type Null Key Default Notes name varchar(50) The English name of the country - this is the primary key. continent varchar(60) Not strictloy continent - but these include all your favourite continents (Europe, Asia etc) plus a few others. area decimal(10,0) YES null population decimal(11,0) YES null gdp decimal(14,0) YES null capital varchar(60) YES null tld varchar(5) YES null flag varchar(255) YES null
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 http://www.wikidata.org - it may be a little out of date. The latest version can be found at Some changes have been made to the data - the reader should assume that errors and omissions are due to me and not the most excellent wikidata site.
The area is measured in square kilometers.
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.
|Language:||English • Deutsch|