The program named create$\_$cities$\_$db$.$py given below.

Run the program. The program will create a data base named cities.db$.$

The cities.db database will have a table named Cities, with the

following columns:

The CityName column stores the name of a city and the Population column stores the population of that city.

After you run the create$\_$cities$\_$db$.$py program, the Cities table will contain $20$ rows with various cities and their populations.

Next, write a program that connects to the cities.db database, and allows the user to select any of the following operations:

Display a list of cities sorted by population, in ascending order.

Display a list of cities sorted by population, in descending order.

Display a list of cities sorted by name.

Display the total population of all the cities.

Display the average population of all the cities.

Display the city with the highest population.

Display the city with the lowest population. in py