This is an introduction to the next few questions. No response is needed for this item.

The world database is a built$-$in schema of MySQL containing information about more than $200$ countries and $4000$ cities of the world such as their population, capitals, languages spoken, area, and economy size, etc. The database stores its information in three tables that are connected with each other by relationships: country, city, and countrylanguage. In the following questions, you may assume that world has been set as the default database. To be automatically graded by Canvas, you must type your answer exactly the way that MySQL accepts in the shortest possible form with no unnecessary spaces.

Write a query to list all Asian countries by name whose LifeExpectancy is $70$ or below, from the highest to the lowest.

Write a query to list all the countries by their names together with the average size of its cities$$ populations, from the largest to the smallest.