GISQ: Tutorial One: Notes 1






A Gentle
Introduction
to



SQL

Tutorial One
Notes 1
CIA World Factbook database.
Some points to note:

You should a table called CIA with 265 record
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

Some columns or rows may only be seen by scrolling; some
SQL engines may spread records over more than one line.
It may be possible to resize the widths of the columns.

An extract from the table cia

nameregionareapopulationgdp
'Yemen''Middle East'5279701472847423400000000
'Zaire''Africa'23454104406063618800000000
'Zambia''Africa'75261094457237900000000
'Zimbabwe''Africa'3905801113996117400000000


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 1995.
The latest version can be found at http://www.odci.gov. The reader should assume that errors in
the data have been introduced during the data transfer.
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 109 or
6.23 x 1000000000 (nine zeroes).
A Million is 106 or 1000000
A Billion is 109 or a thousand million.
A Trillion is 1012 or a million million.