world.sql.zip is a sample database containing data about countries of the world, their cities, and the languages spoken in each. world-setup-en.pdf contains the setup instructions.

Using your knowledge of SQL, determine the following information:

* What is the country code of the Philippines? Of Argentina? Of Nepal? * What are the cities of the Philippines? Of New Zealand? Of Afghanistan? * What country has the largest population? What country has the smallest population? * Which countries speak German as their official language? * What is the most populous city and which country is it located in? * What is the most populous capital city? What is the least populous capital city?

Do some other queries. Make use of SQL joins to execute more complex queries.