| Assignment-1: IR from a MySQL database |
|---|
Assigned on: 08/20/2008, Due on: 08/24/2008
|
| Answer the following questions using the 'world' database. Present your SQL queries and/or processes that you use to derive the answers. |
Email your answers to the instructor with "INLS 490: Assignment-1" in the subject field.
|
| 1. How many countries have English as their official language? (1 point) |
| 2. How many countries became independent in the 20th century? (1 point) |
| 3. How many people in the world are expected to live 75 years or more? (1 point) |
| 4. List the 10 most populated countries in the world with their population as % of the world population. (2 points) |
| 5. List the top 10 countries with the highest population density. (2 points) |
| 6. List the capitals of all the Baltic Countries. (3 points) |
Chirag Shah | Last update: December 19, 2008 |