Using World database on MySQL Server as the sample database, write SQL statements to solve the following questions (5points/each).

1. In which countries English and two or more other languages are official?

2. Show the population density of regions.

3. Show the average life expectancy of continents.

4. Order countries by the descending order of the number of languages spoken in them (official or not).

5. In which countries the total population of cities with more than 1,000,000 inhabitants is greater than 5,000,000?

6. What percent of the world's population lives in each region?

7. Create a list that sorts countries whose country code ends with an P based on the number of their cities.

8. Which eight countries have the most number of cities among the top 100 cities by population?

9. For the top 150 cities in the world, which 20 countries have the highest overall population?

10. Which territories or states in the country table are not independent countries?