3. Develop a database program that creates a database named cities.db. The cities.db database must have a table named Cities, with the following columns:

Question

42 users unlocked this solution today!

3. Develop a database program that creates a database named cities.db. The cities.db database must have a table named Cities, with the following columns: Column Name Data Type I Attributes City Name Text CityID Population Integer Real Primary Key The CityName column stores the name of a city and the Population column stores the population of that city. Write a program that connects to the cities.db database, and allows the user to perform any of the following operations: Display a list of cities sorted by population, in ascending order. 0 Display a list of cities sorted by population, in descending order. Display a list of cities sorted by name. 0 Display the total population of all the cities. Display the average population of all the cities. 0 Display the city with the highest population. Display the city with the lowest population. (20)