Case study

We want to know the countries that don't host a megapolis

The purpose of this exercice is to evaluate your skills in Python and SQL. You'll have to fork this repository and write a program that fetch the dataset of the population of all cities in the world, stores it in a database, then perform a query that will compute: what are the countries that don't host a megapoliss (a city of more than 10,000,000 inhabitants)?

The program will save the result (country code and country name) as a tabulated separated value file, ordered by country name.

You should answer as if you were writting production code within your team. You can imagine that the program will be run automatically every week to update the resulting data.

Please send us the link to your github repository with the answer of the exercise.