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?
Use of database
We help you get better grades, improve your productivity and get more fun out of college!!
Get 25% Discount on Your First Order
How it works – it’s easy
Place your Order
Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.
Make a payment
The total price of your order is based on number of pages, academic level and deadline.
We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to make sure that the assignment meets all of your requirements.
Once complete, we’ll send your assignment via the email provided on the order form.