#### 7.3 Statistics

LinLogBook owns a simple interface to define statistics. It uses the sql table statistics
which has the following definition:

create table statistics (MenuText UNIQUE NOT NULL,sql NOT NULL);

The first column contains the name of entry in the Statistics menu. The second entry
contains the corresponding sql statement to calculate the desired statistic.

You find two examples in the file Statistics.sql. The first example counts the
number of confirmed and unconfirmed qsos for each worked band and mode whilst
the second example counts the worked and confirmed qsos for each country. This
example requires the cty.dat file to be imported.

You implement this statistics by running Update Base Tables from the Edit menu.
Select the file Statistics.sql for this update.After restarting LinLogBook the statistics
are available.

You can implement your own statistics by updating the statistics table. Have a
look at the Statistics.sql file for some explanations.