CMIS 320
Name:____________________________

Download the world_access_txt.zip from the class Web site DBs directory.
Use the world_access.txt handout as a guide to using Access.
Create a blank database in Access and Import the 3 files to create the 3 tables.

Answer these by using the Sorting and Filtering features.
Just show the answers.

1. What country is most recently independant?

2. Who is (still, again) the boss of Russia?

3. What's the most populous city in China?

4. How many cities of Nigeria (NGA) are there?

5. Of those, how many are in the Ogun district?

6. What populated "countries" not ruled by Queen Elizabeth 
 have blank/Null for LifeExpectancy?

7. Of the European countries that became independant after
 1990 and which have a population of more than 4,000,000,
 which ones have a life expectancy greater than 70 years?

8. Of the official languages that are "spoken" by 0 percent
of the population, how many countries have one that is not
English?

9. What are the cities in USA with population more than one million:



Answer these by making a Query that precisely answers the question.
Paste the answer and the SQL.
Hint: some of these you can make the SQL first, then look at the GUI.

1. What is the world's population and total surface area?

2. How many "countries" are not independent? (0 for IndepYear)

3. Of the countries that are independent, what is the average year of indepedence?

4. How many countries are in each continent:

5. The city districts whose populations are more than 15,000,000.

6. What are the English kind of languages?


**************************************************
SKIP all these:
 How many different Languages are in the CountryLanguage table?
distinct OK     count(di... NO!
5. How many different CountryCodes are in the CountryLanguage table?
6. How many Codes are in the Country table?
10. How many "districts" of USA in the City table:
11. How many cities on average are in each USA district:
13. What language is spoken in the most number of countries:
What are the countries of the country table that are not in the countrylanguage table. 
 hint: use a subquery.