Calvin
 
 
Home Page
Homeworks
Lab Projects
Log Out
 
 
Help
 
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:

name
Aethelred II

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