Activity 4.01 – collecting information for a travel article

For a travel magazine, you need to collect some information from the world schema to add bits of trivia to some of the articles in next month's edition. The information that is requested is this:

• What is the population size of the smallest city in the database?
• How many languages are spoken in India?
• Which languages are spoken in more than 20 countries?
• What are the five biggest cities in the "Southern and Central Asia" region?
• How many cities have a name that ends with "ester"?

Follow these steps to complete this activity:

1. Connect to the world schema with a MySQL client.
2. For each question, follow a few basic steps:
   • Select the tables that we need.
   • Filter out the rows that we need.
   • Aggregate the rows if needed.
   • Select the fields that we need.

     Note

     The solution for this activity can be found in the Appendix.

In this activity, you collected the required...