PoleListCont

What you need to know about the database

Summarise palaeomagnetic activity by continent

Leading query segment:
SELECT

Middle query segment:

	Table column name		Alias (esp. for functions - see examples)	Display as column in output table
1		AS		Continent
2		AS		Number of results
3		AS		Total sites
4		AS		Total samples
5		AS		Minimum rock age
6		AS		Maximum rock age
7		AS		First published result
8		AS		Latest published result
9		AS
10		AS

Trailing query segment:
FROM REFERENCE R, ROCKUNIT RU, PMAGRESULT PMR WHERE R.REFNO = RU.REFNO AND RU.ROCKUNITNO = PMR.ROCKUNITNO GROUP BY CONTINENT ORDER BY COUNT(RESULTNO)