Youre now ready to begin. Answer each question below by creating an SQL query using SQLite as described above. Create a document with your name and assignment number at the top. For each exercise, state the question and provide a screen capture showing the SQL statement you wrote along with the results it produced. For example, if an exercise asked you to display the name and surface area of all countries in the continent of Antarctica, you would provide a screen shot like the one in the figure below.

1. Show the name, continent, and population of every country whose population is under 100,000. Order your results by population from highest to lowest.

2. Show the name and population of every country in the continent of Oceania whose population is at or above 20,000. Order your results by country name.

3. Display a list of every continent and present the list in alphabetical order.

4. Of all the countries located in Asia, which has the highest life expectancy?

5. Display the name, continent, and population of every country in Europe and Asia. Order the results by Continent, and then by country name within the continent.

6. Display the name, continent, and population of all countries with island in their name.

7. Display a list of countries that have gained their independence since 1950.

8. Show the top ten countries with the highest gross national product (GNP).

9. Show, for each region of the world, the countries in that region ranked by highest to lowest surface area; order the continents alphabetically.

10. Display a list of the ten highest populated cities in the world.

CI5 171 Chapter 7 AssignmentE x+ C G Search Google or type URL JavaScnpt&JOuery:Anzona State Univers S IM Chos Advanced L CIS 171 Chapter 7 Assignment B.pdf 213 SELECT Name, SurfaceAr FROM Country WHERE Continent = 'Antar ctica'; Name SurfaceArea 13120000.0 Antarctica 2 Bouvet Island 3 South Georgia and the South Sandwich Islands 3903.0 4 Heard Island and McDonald Islands 5 rows returned in lms from: SELECT Name, SurfaceArea FROM Country WHERE Continent'Antarctica' 11:26 PM E O Type here to search Ci rP i q': 11/10/2018