Describe the database
Describe each table (table name, column names, and column datatypes).
- What is the population of Haiti?
- Display the country and leader of countries whose leaders’ names start with Robert.
- Display all information for USA cities with a population of over a million
- Display the name and population of cities in New Mexico.
- 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).
- Display the names and leaders of countries with populations between one and two million people.
- Display the names of countries with populations between one and two million people and a land mass greater than 100,000.
- Display country codes of countries whose official language is Arabic and spoken by over 50% of the population.
- Display name of cities in the USA which start with the letter ‘L’.
- 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).