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