Question: Please take a screen shot for each excercise that it works Youre now ready to begin. Answer each question below by creating an SQL query

Please take a screen shot for each excercise that it works

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.

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.

Screen Shot Should looks like this.

Please take a screen shot for each excercise that it works Youre

now ready to begin. Answer each question below by creating an SQL

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!