Worksheet 1

Describe the database

Describe each table (table name, column names, and column datatypes).

1. What is the population of Haiti?
2. Display the country and leader of countries whose leaders’ names start with Robert.
3. Display all information for USA cities with a population of over a million
4. Display the name and population of cities in New Mexico.
5. Display the names and land mass size of countries in North and South America. (in the sheet you turn in just show the first 3 results).
6. Display the names and leaders of countries with populations between one and two million people.
7. Display the names of countries with populations between one and two million people and a land mass greater than 100,000.
8. Display country codes of countries whose official language is Arabic and spoken by over 50% of the population.
9. Display name of cities in the USA which start with the letter ‘L’.
10. Display city name and country code and population of cities of a population of over 5 million in Japan (JPN), China (CHN), and Korea (KOR).