|
Version 2.31i, Aug 15, 2004 Copyright © 2003-2004 Gradiance Corporation
|
|
|
Gradiance Online Accelerated Learning
|
Results from Example Database
|
|
|
Your query:
SELECT name FROM Kings
WHERE beginReign <= 1000
AND endReign >= 1000
Results of your query from example database:
The results you should have gotten:
name
| nickname
| Aethelred II |
The Unready |
Example Database:
Table: Kings
name
| nickname
| house
| beginReign
| endReign
|
Egbert |
|
Wessex |
802 |
839 |
Aethelwulf |
|
Wessex |
839 |
855 |
Aethelbald |
|
Wessex |
855 |
860 |
Aethelbert |
|
Wessex |
860 |
866 |
Aethelred I |
|
Wessex |
866 |
871 |
Alfred |
The Great |
Wessex |
871 |
899 |
Edward the Elder |
The Elder |
Wessex |
899 |
925 |
Athelstan |
|
Wessex |
925 |
940 |
Edmund the Magnificent |
|
Wessex |
940 |
946 |
Eadred |
|
Wessex |
946 |
955 |
Eadwig |
All-Fair |
Wessex |
955 |
959 |
Edgar |
The Peacable |
Wessex |
959 |
975 |
Edward the Martyr |
|
Wessex |
975 |
978 |
Aethelred II |
The Unready |
Wessex |
978 |
1016 |
Edmund Ironside |
Ironside |
Wessex |
1016 |
1016 |
Svein |
Forkbeard |
Danish |
1014 |
1014 |
Canute |
The Great |
Danish |
1016 |
1035 |
Harald I |
Harefoot |
Danish |
1035 |
1040 |
Hardicanute |
|
Danish |
1040 |
1042 |
Edward the Confessor |
|
Wessex |
1042 |
1066 |
Harald II |
|
Wessex |
1066 |
1066 |
William I |
The Conqueror |
Norman |
1066 |
1087 |
William II |
Rufus |
Norman |
1087 |
1100 |
Henry I |
Beauclerc |
Norman |
1100 |
1135 |
Stephen |
|
Norman |
1135 |
1154 |
Matilda |
|
Norman |
1141 |
1141 |
Henry II |
Curtmantle |
Angevin |
1154 |
1189 |
Richard I |
The Lionheart |
Angevin |
1189 |
1199 |
John |
Lackland |
Angevin |
1199 |
1216 |
Henry III |
|
Angevin |
1216 |
1272 |
Edward I |
Longshanks |
Angevin |
1272 |
1307 |
Edward II |
|
Angevin |
1307 |
1327 |
Edward III |
|
Angevin |
1327 |
1377 |
Richard II |
|
Angevin |
1377 |
1399 |
Henry IV |
Bolingbroke |
Lancaster |
1399 |
1413 |
Henry V |
|
Lancaster |
1413 |
1422 |
Henry VI |
|
Lancaster |
1422 |
1471 |
Edward IV |
|
York |
1461 |
1483 |
Edward V |
|
York |
1483 |
1483 |
Richard III |
Crookback |
York |
1483 |
1485 |
Henry VII |
Tudor |
Tudor |
1485 |
1509 |
Henry VIII |
|
Tudor |
1509 |
1547 |
Edward VI |
|
Tudor |
1547 |
1553 |
Jane Grey |
|
Tudor |
1553 |
1553 |
Mary I |
Tudor |
Tudor |
1553 |
1558 |
Elizabeth I |
|
Tudor |
1558 |
1603 |
James I |
|
Stuart |
1603 |
1625 |
Charles I |
|
Stuart |
1625 |
1649 |
Oliver Cromwell |
|
Commonwealth |
1649 |
1658 |
Richard Cromwell |
|
Commonwealth |
1658 |
1659 |
Charles II |
|
Stuart |
1660 |
1685 |
James II |
|
Stuart |
1685 |
1688 |
William III |
|
Orange |
1689 |
1702 |
Mary II |
|
Stuart |
1689 |
1702 |
Anne |
|
Stuart |
1702 |
1714 |
George I |
|
Brunswick-Hanover |
1714 |
1727 |
George II |
|
Brunswick-Hanover |
1727 |
1760 |
George III |
|
Brunswick-Hanover |
1760 |
1820 |
George IV |
|
Brunswick-Hanover |
1820 |
1830 |
William IV |
|
Brunswick-Hanover |
1830 |
1837 |
Victoria |
|
Brunswick-Hanover |
1837 |
1901 |
Edward VII |
|
Saxe-Coburg-Gotha |
1901 |
1910 |
George V |
|
Windsor |
1910 |
1936 |
Edward VIII |
|
Windsor |
1936 |
1936 |
George VI |
|
Windsor |
1936 |
1952 |
Elizabeth II |
|
Windsor |
1952 |
|
|
|