Using the World-X database found here: dev.mysql.com/doc/index-other.html

Write a Python script to increase the population of each city in the world_x database by 10% (rounded).

First, add a new column to the world_x city table using the following MySQL command:

• ALTER TABLE `world_x`.`city` ADD COLUMN `Population` DOUBLE NULL DEFAULT NULL AFTER `Info`;

The existing population data are stored as JSON datatype in the city table in a field named Info. You learned about JSON data types in Module 2. To obtain the population data from the Info column in the city table, run the following MySQL command:

• select info->$.Population from city

Your Python script should do the following:

• Copy the population data from the Info column into the Population column,
• Increase the population by 10% in the Population column, and
• List the population before the increase and the population after it was increased.

Please type the answer out.