Answered You can hire a professional tutor to get the answer.
This homework use database world. You need to access the table x in the database using world. Get familiar with the tables in the database.
This homework use database world. You need to access the table x in the database using world.x . Get familiar with the tables in the database. Show the SQL query and the output AND the answer to the question. DO NOT provide IDs in the final answer; all answers should be meaningful.
1. How many California cities are on record?
2. Which East Coast cities (Maine, New Hampshire, Massachusetts, Rhode Island, Connecticut, New York, New Jersey, Delaware, Maryland, Virginia, North Carolina, South Carolina, Georgia, and Florida) have less than a million people?
3. Which Asian cities have more than 8 million people and are in a country where the life expectancy is under 65?
4. How many countries outside Europe have French as their official language?
5. Which cities of at least 75 0,000 but no more than a million people are in countries where Spanish is the official language?
6. How many countries are in the continent of North America?
7. What are the names and capitals of the countries in Oceania?
8. What different forms of government are there in South America? 9. What country has the smallest GNP and how small is it?
