1-5) Make a table that looks like the table below.  Insert the data.
Type will always be rocky or gas.  Length of year is always between 0.24 and 247.7.  No plant has more than 20 moons.  Name is never null.  The default number of moons for a planet should be zero.  Index the field name.

Choose types that BEST FIT this data, and that MINIMIZE table space.
 

Name	NumMoons	Type	LengthOfYear
Mercury	0	Rocky	0.24
Venus	0	Rocky	0.62
Earth	1	Rocky	1
Jupiter	16	Gas	11.86
Saturn	18	Gas	29.46
Pluto	1	Rocky	247.7

Scoring:  1 point for making a table, one point for getting the right types, one point for the index, and one point for inserting the data.  Make the table, and show me the results of "select * from tablename" and "describe tablename".

6)  Using the 'nations' database, what is the nation with the smallest area amoung planets with more than 20 million people?
 
 

7)  What is the length of the border between Kenya and Tanzania?
 

8) What is the second most popular religion in the world?
 

9) How many Muslims in Germany?
 

10) What is the name of the nation with code = "up"?
 

11) How many nations have the map reference "Africa"?