Question: Needing SQL Statements that works with the World Sample Database provided by MySql Server! ( 1 . Find out the average population and the total

Needing SQL Statements that works with the "World" Sample Database provided by MySql Server! (

1 . Find out the average population and the total number of cities for each country, and sort the result first by continent and second by average population.

2. Find out the average population and the total number of countries for each continent, and sort the result first by continent and second by average population.

3. Find out the official languages of the top 10 GNP countries, and sort the result by GNP.

4. Find out the official languages spoke by the top 10 populated counties, and sort the result by population.

5. Find out the biggest and the smallest city of each continent (country.continent, country.name).

6. Find out what country has the highest population but has the minimum surface area.

The World Schema/DB can be downloaded from https://dev.mysql.com/doc/index-other.html

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!

a2.sql ----------------------------------------------------------------------------- -- Add below your SQL statements. -- You can create intermediate views (as needed). Remember to drop these views...

Assignment 3 Instructions Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the...

World Traveler Cruise Line SHIP Ship Nurriter Ship Name Weight Year Built Passenger Capacity CRUISE Cruise Serial Number Sailing Date Return Date VISITS Visit Order BOOKING Price Satisfaction Rate...

Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the requested queries in SQL....

Can you answer the questions I squared on the red below? Thank you very much, I really appreciate your work. Create a database in SQLServer for the relational model provided in the HW3- Relational...

Using World database on MySQL Server as the sample database, write SQL statements to solve the following questions (5points/each). 1. Select the cities (*) in the United States of America or Brazil,...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Objective: The objective of this assignment is to get more experience in SQL and Relational Databases. Basically, you will design, create, and write SQL queries using MySQL DBMS. Requirements: In...

For the COMPANY database, write the proper SQL Statements to answer the following queries using MySQL DBMS. To install MySQL Server in your own environment, please see Web links posted on Course Web...

PGAS shares on the Indonesia Stock Exchange have an expected return for the next year of 14.6% and a beta of 1.1. The SPN (risk free) interest rate for the next year is 4.8%. a. What is the risk...

Which of the following actions must you perform in relation to the financial interests of your spouse prior to getting married? Explain to your spouse that you must monitor constantly your financial...

1. What are the major lessor groups? What advantage does a captive leasing subsidiary have in a leasing arrangement?

You purchase a bond with an clean price of $1,142. The bond has a coupon rate of 7 percent, and there are 4 months to the next semiannual coupon date. What is the dirty price of the bond? Enter the...

1 How could the problems in the Blue Sword joint venture, leading to its eventual failure, have been avoided?

Praise. Companies do not praise their employees very often. Individual praise in front of the group is not often used deliberately except in the hotel industry. A view elsewhere is that this may be...

Pressure and punishment. Direct punishment was found only in the hotel sector, where some companies punish their staff for bad behaviour and not working. Deductions from salary or bonuses are seen to...